View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
HEK
 
Posts: n/a
Default HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?

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.