Create an XY Scatter Graph in Excel | Scatter Plot with Multiple Data Sets | Include Trendline

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍

In this video, I demonstrate how to create an XY scatter graph in Excel. An X Y scatter plot is used to explore the relationship between data sets. In my example, I look at the relationship between a day's top temperature and sales of ice creams, burgers and pies.

I would expect ice cream sales to increase as the temperature increases, but is this true and is it true for burgers and pies? A scatter graph will clearly show whether there is a correlation.

I also show you how to add multiple series to a scatter graph. You can either show all series in one graph or in separate graphs. I will show you the most efficient method for achieving both outcomes!

Lastly, I also demonstrate how to include a trendline in your scatter graph and how to forecast forward or backward based on existing data. So for example we might want to forecast sales of ice creams with a top temperature of 40 degrees celcius (pretty unlikely in the UK!). In addition, I demonstrate how to use the FORECAST.LINEAR function which will give an exact value for the forecast.
------------------------

[IvanCortinas_ES]

Excellent tutorial. I love these statistics videos because I learn a lot. Thank you Chester!

[rararedroses]

thank you ! i was finding it to guide me for my assignment

[wallieshere]

Thanks again. I'm using Bounds for Time on the X-axis, how is the Time datatype related to the Minimum and Maximum numbers?

[katherineestrada]

Have my x axis labeled for example grapes, apples, and oranges how would I do that not the title but in the x axis

[aneesasheraz]

hi.. what if the temperature is in negative?

[silviopoggi]

Mr. Tugwell, How the devil do you keep your brain from over