View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.