Create an Dynamic Scatter Chart

If you're creating X Y scatter charts, sometimes you'd have multiple series of data, but you're not needing to compare them to each other. Rather you just want to show them in the same chart without making multiple scatter charts. It's not too hard to put them into one chart and have a button give you the option to select one or another. Check out the video to learn how!
🔔 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...
~-~~-~~~-~~-~

[@oy8717]

Thanks for your video. That's what I am looking for!!!

[@DougHExcel]

You're welcome!

[@OwenGeeAndre]

This is nice, helped me a lot

[@DougHExcel]

Thanks!

[@reikaando5426]

this is exactly what i wanted to do, thanks!

[@DougHExcel]

Glad to hear it!

[@worldoftone]

Good advanced class thanks!

[@DougHExcel]

Glad you enjoyed it!

[@dhanienugroho4323]

Very helpful

[@DougHExcel]

Glad it helped!

[@spuneet156]

Easy and useful

[@DougHExcel]

Hi demon is watching, thanks for the comment!

[@spuneet156]

@@DougHExcel do you have some hacks over dashboard preparation in Excel

[@spuneet156]

And quick processing over large csv files

[@spuneet156]

Please suggest

[@DougHExcel]

Here's some videos covering dashboards charts ruclips.net/p/PL-n8f1cY_Qw8UMgxYBiKbgbqpPw6Esz-d

[@costaricantrader5704]

I am trying to do this but excel is letting me do a scatter chart without selecting the data first, or putting data out of the pivot table. I have everything in pivots.

[@jaybrusse]

excellent demo. Can you take this same example one step further and give instructions/advice on what you would do if you wanted to COMPARE GROUPS 1, 2 and 3 (or combinations of them selected by SLICER) SIMULTANEOUSLY on the same XY scatter chart and have each group with a unique marker/color?

[@DougHExcel]

It might become difficult to make comparison all in one chart. Another option could be the panel chart approach. ruclips.net/user/DougHExcelsearch?query=panel

[@williamseitz5057]

Hi there, is there a way to link each plot point to the student associated with it? So that if you click or hover over a data point you can see which student it represents? Thanks so much.

[@DougHExcel]

one of these might help ruclips.net/user/DougHExcelsearch?query=scatter%20label

[@williamseitz5057]

@@DougHExcel Hi Doug, thank you so much for the reply. Unfortunately, I have hundreds of data points on my scatter chart and so it is difficult to read the labels due to overlap. Ideally, it would be great if the labels did not show up automatically in the chart, but rather you could see the label by hovering over each individual data point. Any tips on how to do that? Thanks again.

[@DougHExcel]

I don't think there's an option for that, but probably can be done with VBA