Тёмный

Add Multiple Series of Data to X Y Scatter Chart 

Doug H
Подписаться 78 тыс.
Просмотров 78 тыс.
50% 1

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.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 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!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Опубликовано:

 

1 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 50   
@xiaoranlin8918
@xiaoranlin8918 Год назад
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
@DougHExcel
@DougHExcel Год назад
Glad it helped!
@ericsheppard8375
@ericsheppard8375 5 месяцев назад
Really clear and helpful!
@DougHExcel
@DougHExcel 5 месяцев назад
Glad it was helpful!
@user-oj1uj9dx8k
@user-oj1uj9dx8k 11 месяцев назад
Thank you so so much. You have no idea how much I needed this
@DougHExcel
@DougHExcel 11 месяцев назад
Thanks Jake Keyes, glad it helped!
@wayneedmondson1065
@wayneedmondson1065 4 года назад
Hi Doug.. great tips! Thanks for sharing. Thumbs up!!
@DougHExcel
@DougHExcel 4 года назад
Wayne! Appreciate your comments!
@emmetk1786
@emmetk1786 2 года назад
Thanks for making this! Really helpful tip to paste special, which I never knew about before
@DougHExcel
@DougHExcel 2 года назад
Glad it was helpful!
@stephaniewilson537
@stephaniewilson537 2 года назад
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!
@DougHExcel
@DougHExcel 2 года назад
Glad it helped!
@jobenoctavo1502
@jobenoctavo1502 3 года назад
This a great time saver for handling mountains of data points.
@DougHExcel
@DougHExcel 3 года назад
Hi joben octavo, thanks for the comment!
@CaydenDye-lo3sh
@CaydenDye-lo3sh 4 месяца назад
your a legend mate
@jillbudd9512
@jillbudd9512 2 года назад
OMG This saved so much time. Thanks!!!!
@DougHExcel
@DougHExcel 2 года назад
Great to hear!
@arianadanna268
@arianadanna268 Год назад
Omg this is exactly what I needed and I never would have figured that out myself thank you
@DougHExcel
@DougHExcel Год назад
Thanks Ariana D'Anna, glad it helped!
@KidWizard1
@KidWizard1 2 года назад
Useful. Thanks for the help.
@DougHExcel
@DougHExcel 2 года назад
Glad it helped!
@arrtwo1375
@arrtwo1375 10 месяцев назад
Thanks, this helped me so much at work!
@DougHExcel
@DougHExcel 10 месяцев назад
Glad it helped!
@ostanin_vadym
@ostanin_vadym 2 года назад
Thank you. Your video helped me alot.
@DougHExcel
@DougHExcel 2 года назад
Glad it helped!
@calebjimmysmith
@calebjimmysmith 9 месяцев назад
Gotta love that copy paste special.
@DougHExcel
@DougHExcel 9 месяцев назад
Totally agree!
@olgaandreeva8938
@olgaandreeva8938 2 года назад
Thanx a lot for your video! it helped me much
@DougHExcel
@DougHExcel 2 года назад
Glad it helped!
@esan120au
@esan120au 2 года назад
That paste special rocks!
@DougHExcel
@DougHExcel 2 года назад
Yes it does!
@stevennye5075
@stevennye5075 4 года назад
well done!
@DougHExcel
@DougHExcel 4 года назад
Thanks Steven Nye!
@thamnosma
@thamnosma 3 года назад
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.
@DougHExcel
@DougHExcel 3 года назад
Glad I could help!
@angelicapayan9693
@angelicapayan9693 2 года назад
Thank you so much!!! This video helped a lottttttttttt!!!!!!!
@DougHExcel
@DougHExcel 2 года назад
Thanks, glad it helped!
@charlespendragon1742
@charlespendragon1742 Год назад
OMG, that's quite useful! Rescue my job!
@DougHExcel
@DougHExcel Год назад
Glad it helped!
@christinoboyke5838
@christinoboyke5838 3 года назад
THANKS
@DougHExcel
@DougHExcel 3 года назад
You're welcome!
@lovekishorbista6687
@lovekishorbista6687 Год назад
My excel defining own x axis and ploting both the columns even when categorising first column as x axis
@Eli-tp8wg
@Eli-tp8wg Год назад
same
@NimishP
@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?
@majidsiddique8227
@majidsiddique8227 4 года назад
Execellent
@DougHExcel
@DougHExcel 4 года назад
Thanks!
@PorpoiseSeeker
@PorpoiseSeeker 2 месяца назад
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
@larreldailey5755
@larreldailey5755 2 года назад
Do you know if this also works in the office version of excel on the microsoft office website?
@DougHExcel
@DougHExcel 2 года назад
Hi Larrel Dailey, thanks for the comment! Haven't tried but if you do try share in the thread!
@joesupplebruns262
@joesupplebruns262 3 года назад
COLD COFFEE SALES OR HOT . COFFEE SALES
Далее
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Excel: Two Scatterplots and Two Trendlines
7:36
Просмотров 255 тыс.
The English Language in 65 Accents
13:42
Просмотров 2,1 млн
Quickly Add a Series of Data to X Y Scatter Chart
5:13
How to Add MULTIPLE Sets of Data to ONE GRAPH in Excel
3:44
Create Quadrant Lines for an XY Scatter Chart
12:05
Просмотров 95 тыс.