Add Multiple Series of Data to X Y Scatter Chart

If you're creating a scatter plot it may begin with one series of x,y data. But later on you may want to put a second set of data or a second line into your chart. You may have 2 variables, 3 variables or multiple variables! Basically this are multiple groups or multiple sets of data and you'd want to plot two or more things at once. This vid will show you how to quickly add multiple scatter plots into your graph chart and even cover labeling your series of data. Well it covers more of how to label your series of data via the legend and even though Excel can give you two or more colors to separate out those series, you may want to use markers to help differentiate it more.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[xiaoranlin]

I spent an hour finding the right way to do this, until I came across this video. You are an absolute savior. Thank you so much

[ojujdxk]

Thank you so so much. You have no idea how much I needed this

[emmetk]

Thanks for making this! Really helpful tip to paste special, which I never knew about before

[arrtwo]

Thanks, this helped me so much at work!

[lovekishorbista]

My excel defining own x axis and ploting both the columns even when categorising first column as x axis

[charlespendragon]

OMG, that's quite useful! Rescue my job!

[jillbudd]

OMG This saved so much time. Thanks!!!!

[jobenoctavo]

This a great time saver for handling mountains of data points.

[stephaniewilson]

Thank you very much for this! It was exactly what I needed to know and I was able to create my scatter plot in a couple of minutes!

[arianadanna]

Omg this is exactly what I needed and I never would have figured that out myself thank you

[angelicapayan]

Thank you so much!!! This video helped a

[olgaandreeva]

Thanx a lot for your video! it helped me much

[wayneedmondson]

Hi Doug.. great tips! Thanks for sharing. Thumbs up!!

[thamnosma]

Thank you so much. I viewed another tutorial and the guy just highlighted more data and I have no idea how he got the scatter chart to work. You get the chart open, pasted another column and extended the highlighted area. That worked perfectly. I was going crazy.

[PorpoiseSeeker]

I’m on macOS with excel 365. The Select Data Source window is different. My columns have 744 data.
I try to add a new series and get a message that the chart data range is too complex to be displayed.
This must be a result of a fatal improvement. I have need successfully doing this by simply selecting the new column, copy, past into heath. That no longer works and neither does this select data trick

[NimishP]

Thanks for the tutorial.

I’ve a question? I have a XY values, but in a following format.

Item, XPosition, YPosition

I want to plot XY graph for entire data set, but have different type of marker for different values of Item field. Is it possible?

[larreldailey]

Do you know if this also works in the office version of excel on the microsoft office website?

[joesupplebruns]

COLD COFFEE SALES OR
HOT . COFFEE SALES