I have several bubble plots which I'm using the bubble size to show one of three strategic scores. In many cases the score for the Z-Axis (size) will be Zero, so that point doesn't show up on the chart. How can I set the Z-Axis scale of a bubble plot to show Zero's as the smallest bubble size rather than one's as the smallest bubble size?
I've tried this approach: http://peltiertech.com/Excel/Charts/ControlBubbleSizes.html
with the smallest value being -1 or -5. Didn't work.
Using Excel 2013, Windows 7.