Forum Discussion
Scatter plot with Conditional formatting
See the attached demo workbook.
See thge attached version.
Click on the chart, then click Select Data on the Chart Design tab of the ribbon.
Select the series, then click Edit to see how the x-values, y-values and bubble size are defined.
I can see that we have Selected Data the same way. But I still get it wrong, when i download the file you've attached I can't spot the difference.
When i try to do it I can only do one of the things at a time.
So i can either plot it with the correct X/Y, or I can get the colors right.
I've posted the screenshot in the post along with an Excel sheet with my data, if you want to look at what I'm doing wrong 🙂
My demo has only a single series. It has a single color initially The colors are applied by running the macro (click the button).
- I see, i can't use macros at my work place (IT security disabled it for some reason). Is it possible to do it without it?
It gets ugly without VBA. You have to create separate ranges for each color, and you'll have to apply the colors manually. Excel cannot read the colors from the source range automatically.