On Thu, 5 Jul 2007, in microsoft.public.excel.charting,
Marci Brooks said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.