HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?

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

Guest

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Bubble Chart Legend 10
change bubble order in a bubble chart 1
Making a Bubble Chart with 4 variables instead of 3 1
very odd bubble chart problem 3
Bubble Sizes in Bubble Chart 1
How do I create Multiple Series in a Bubble Chart? 2
Names on a Bubble Chart 2

Top