Forum Discussion
MadsBV
Mar 25, 2024Copper Contributor
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...
- Mar 25, 2024
See the attached demo workbook.
HansVogelaar
Mar 25, 2024MVP
MadsBV
Mar 25, 2024Copper Contributor
Hi,
Yes that looks like it would fit my description quite well 🙂
Yes that looks like it would fit my description quite well 🙂
- HansVogelaarMar 25, 2024MVP
See the attached demo workbook.
- MadsBVMar 25, 2024Copper ContributorAlright, I couldn't attach the screenshot in a comment. So i put it in the post instead 🙂
- MadsBVMar 25, 2024Copper ContributorThank 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)- HansVogelaarMar 25, 2024MVP
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.