MS Excel bubble chart question
Discussion
Produced a nice bubble chart - taken me a while to get it just right.
Problem is: I have a big bubble covering a little bubble - so can't get to the little bubble at all without changing the co-ordinates. How can I bring the little bubble forward - like you can do in powerpoint drawings? Any ideas gratefully received.
Would use the stupid paperclip, but its crap - and how do you phrase a question like this that the useless little b&gger would understand!?
Problem is: I have a big bubble covering a little bubble - so can't get to the little bubble at all without changing the co-ordinates. How can I bring the little bubble forward - like you can do in powerpoint drawings? Any ideas gratefully received.
Would use the stupid paperclip, but its crap - and how do you phrase a question like this that the useless little b&gger would understand!?
You need to change the overlap or spacing data markers:
Click a data series in the chart you want to change.
On the Format menu, click Selected Data Series, and then click the Options tab.
To change the overlap of the data markers in each category, enter a value between -100 and 100 in the Overlap box. The higher the value, the greater the overlap within the category.
To change the spacing between categories of data markers, enter a value between 0 (zero) and 500 in the Gap width box. The higher the value, the greater the distance between each category.
Click a data series in the chart you want to change.
On the Format menu, click Selected Data Series, and then click the Options tab.
To change the overlap of the data markers in each category, enter a value between -100 and 100 in the Overlap box. The higher the value, the greater the overlap within the category.
To change the spacing between categories of data markers, enter a value between 0 (zero) and 500 in the Gap width box. The higher the value, the greater the distance between each category.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff