Bubble Charts

[Guest]

Hi,

I have created a bubble chart in excel. I would like the individual bubbles
to have different colours and also for them to have labels that are different
to the data used to size them (ie they are sized on size of customer,
however, I would like the name of the customer to show next to the bubble)

 

[Jon Peltier]

If you have a single series, you can double click on it and on the Options
tab, choose Vary Colors by Point. Otherwise, you can select individual
points (single click to select the series, another single click to select
the point, then double click to format each with a different color). To
apply custom labels to the points, you could apply default labels and edit
the text of each (again, two single clicks to select the individual label,
then edit its text), or you can use one of these free utilities to use a
separate worksheet range for the labels:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon

 

[Guest]

Hi Jon & others -
A new question on coloring bubbles: I have about 50 bubbles on my chart and
each one represents a value for a specific country. I am trying to color the
bubbles based on the region where the country lies (i.e. all countried in
africa = red; all countries in asia = green, etc). Is there a way to do this
through a formula or macro? Or do I have to do it manually, selecting each
bubble separately and then choosing the corresponding color?
Any help is greatly appreciated.

 

[Del Cotter]

A new question on coloring bubbles: I have about 50 bubbles on my chart and
each one represents a value for a specific country. I am trying to color the
bubbles based on the region where the country lies (i.e. all countried in
africa = red; all countries in asia = green, etc). Is there a way to do this
through a formula or macro? Or do I have to do it manually, selecting each
bubble separately and then choosing the corresponding color?

It's much easier to do it by creating extra columns in the spreadsheet
than by writing macros. Like so:

Continent Country Value Asia Africa
Asia China 1.0 1.0 #N/A
Asia Vietnam 1.2 1.2 #N/A
Africa Niger 1.1 #N/A 1.1
Asia Laos 1.3 1.3 #N/A

Imagine that "Continent" is in cell A1; then cell D2 contains the
formula:

= IF ( $B2=D$1, $C2, NA() )

Then you can build your chart from these values. If you want your bubble
chart to build automatically using the Chart Wizard, re-arrange the
columns from the way I have arranged them, using cut and paste.