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. |
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. |
All times are GMT +1. The time now is 02:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com