Forum Discussion
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.
Hi,
Yes that looks like it would fit my description quite well 🙂
Yes that looks like it would fit my description quite well 🙂
See the attached demo workbook.
- Thank you so much! The last problem I have is that my Bubbles don't follow the format i want.
My Bubbles on the x axis follows the ID instead of the probability. (see screenshot below)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 🙂
- Alright, I couldn't attach the screenshot in a comment. So i put it in the post instead 🙂
