Forum Discussion
Solved
Scatter plot with Conditional formatting
Hi everyone, I'm trying to create a scatter plot based on some different variables. I have my ID which i want to be in the center of each *Scatter plot* The "Probability" is my X axis The "Co...
See the attached demo workbook.
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?
You have to click Select Data, select a series then click Edit. You can then specify the correct range for the x-values.
- Yea that's what i did in the left plot, but then the x axis gets weird and uses the id instead of probability. Even though I've selected data the same way.
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.