I am building a dashboard that has several bubble charts. I want the charts to use the same scale so bubbles can be compared between charts, so a bubble with a Sales value of 20 should be the same size of a 20 on other chart. Right now the scale is calculated depending on the max and min values of each chart which causes bubbles in separate charts with the same values have diffferent sizes.
Any ideas? Is there a way to control the scale with a macro?
I have no luck with this. I can't find a way to achieve what I need. Now, I am looking into a way to take the max value for all the charts and create some kind of reference value for all the charts (a fake bubble) that doesn't show but is used as the largest value in every chart. I have no idea right now how to achieve this.
If anyone can think of anything please let me know.
