Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble Sizes in Bubble Chart
Hi, I'm having issues with sizing the bubbles in my bubble chart. I want them
to be uniform, but when I enter the size number for the first one, it changes the size for all other bubbles within the chart. So either there is one HUGE bubble and several small ones on the chart, or there are several huge bubbles and one small one. I've tried starting from scratch, using other numbers for the size; nothing is working. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble Sizes in Bubble Chart
You want the bubbles to be uniform? As in, all the same size? Then use the
same value in the bubble size column for all of the points. They will all be the same size, the default size, which is about 1/4 of the length of the smaller axis (X or Y). To adjust this size, you can format the series, and on the Options tab, change the number in the Scale Bubble Size box. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "MJP08" wrote in message ... Hi, I'm having issues with sizing the bubbles in my bubble chart. I want them to be uniform, but when I enter the size number for the first one, it changes the size for all other bubbles within the chart. So either there is one HUGE bubble and several small ones on the chart, or there are several huge bubbles and one small one. I've tried starting from scratch, using other numbers for the size; nothing is working. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 'bubble' chart where colors are used instead of bubble size | Charts and Charting in Excel | |||
Bubble chart with multiple bubble sizes | Excel Discussion (Misc queries) | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel |