HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I WANT TO CREATE A BUBBLE CHART THAT COULD SHOW WHICH BUBBLE IS FROM WHICH
ROW OR COMPANY IN MY CASE. EACH BUBBLE COULD BE OF A DIFFERENT COLOR.
 
You need three parameters (X,Y, diam) for yr bubbles, which reprersent your
position (x,y) in the chart and the size of the bubble (diameter). The
bubble chart is standard with all bubbles of uniform colour. After you hv
created yr bubble chart, right-click the data series, choose Format Dat
Series/Options and tick "Vary colors by point", and all bubbles have a unique
colour. These can be changed individually if needed.
GL,
Henk
 
Hi,

2 options. Create a series for each company or if you have a single
series enable the 'Vary color by points', which you can get at by double
clicking the series to bring up the format dialog and going to the
Series Option tab.

Cheers
Andy
 
Back
Top