ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Bubble Sizes in Bubble Chart (https://www.excelbanter.com/charts-charting-excel/217660-bubble-sizes-bubble-chart.html)

MJP08

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.

Jon Peltier

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