HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?

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

"Hector" wrote:

> 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.

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

Hector wrote:
> 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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info