Hi All,
I have created a bubble chart, when the values are very small the bubble and label completely disappear. (using excel 2003)
The value of the size data is between 1-761 currently but could conceivably be between 0 and 10000.
I have set the labels as non scalable so although it will not be possible to see the bubble, the label should retain its size - but this also completely disappears.
It appears the bubbles and labels disappear between values of 2 and 3 which represent a % of 0.02 and 0.03 respectively of the total sum of the size population which is 10000.
hope that makes sense - if you need more info give me a shout.
Thanks.
I have created a bubble chart, when the values are very small the bubble and label completely disappear. (using excel 2003)
The value of the size data is between 1-761 currently but could conceivably be between 0 and 10000.
I have set the labels as non scalable so although it will not be possible to see the bubble, the label should retain its size - but this also completely disappears.
It appears the bubbles and labels disappear between values of 2 and 3 which represent a % of 0.02 and 0.03 respectively of the total sum of the size population which is 10000.
hope that makes sense - if you need more info give me a shout.
Thanks.
