Hello,
I'm new here. Was wondering if anyone knows how to color code scatter data points. Example chart attached
Thank you,
Russ
Hello,
I'm new here. Was wondering if anyone knows how to color code scatter data points. Example chart attached
Thank you,
Russ
Given you have Excel 2013, take a look at PowerView. There is an excellent bubble chart visualisation tool available which I am sure will do what you want and more.
http://office.microsoft.com/en-au/ex...102899553.aspx
http://www.youtube.com/watch?v=loHJffQup8k
Last edited by Mallycat; 07-19-2013 at 06:21 PM.
My approach to providing help is to help you to help yourself. So my answers won't always solve your problem, but hopefully you can learn enough to solve the problem yourself and be more self sufficient for the experience.
As your chart is not a true xy-scatter plot, due to the x values being text, you can use a pivot table/chart
Thank you both. Andy that worked perfectly! Thank you again.
Russ
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks