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.
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.
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.
You have to click Select Data, select a series then click Edit. You can then specify the correct range for the x-values.