How to Create and Customize X-Y Scatter Charts in Excel
HTML-код
- Опубликовано: 11 сен 2024
- This video shows how to create a scatter chart (otherwise known as a X Y chart or XY scatter chart). An added capability is to add label names to the scatter chart - something that was not easily done in versions prior to Excel 2013. This video is aimed at those who already have a basic understanding of Excel and want to delve deeper into its charting capabilities. Scatter charts are powerful tools for visualizing relationships between numerical data points. By the end of this tutorial, you'll not only know how to create a scatter chart but also understand how to customize it to fit your data analysis needs.
Thanks in advance for watching our advanced tutorial on X-Y Scatter Charts in Excel. Equip yourself with these expert techniques to transform simple data into compelling stories. If you found this video useful, please like, subscribe, and consider sharing it with your network. Let us know how these strategies work out for you in the comments!
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
Thanks, you save much of my time with this video!
You're welcome!
Very useful especially to show two parameters at time.
Thank you
Hi eada2010, you're welcome!
Super Helpful , Thanks !!
You’re welcome!
Thank you!!!!
You're Welcome!
Thanks
You're Welcome!
Doug - Is it possible to hide the data labels and only have them appear when you hover over the data point? I have a large sample size and having the labels visible makes the chart too busy, but I want to be able to identify what the data points are at the extremes
The two options I can think of to have the hover info capability is creating some VBA (which I'm not good at) or having each individual data point as each own series (probably not feasible if you have a large data set).
I have a lot of dots in my scatter chart. I would like to see name when I point with mouse on dot (Name doesn´t need to stand next to dot). Now I have: Series 1 Point "89" (89, 12,04) and I would like to have: Ivana (89, 12,04). Or something similar, but I would like to have name when I point with mouse on dot.
Appreciate if you can help!
maybe one of these can help ruclips.net/video/bYf6qO-iBW0/видео.html
It's kind of bullshit that the option doesn't show up any more.
Could you do one for mac
Sure...I'll have to look into it...Stay tuned!
Too much talk.
paveldorozkin123, that is very interesting...thanks for letting me know.