I've created some standard x,y,size bubble charts and want to add a forth
variable to show color. Can someone show me how to do that in VBA? Also, I
would like the bubble label to be in the fifth variable.

Turn on the macro recorder while you recolor individual bubbles, then adapt
your code so it reads the cells and applies the appropriate color for that
value.

The bubble label can be added from the worksheet using a utility like this:

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

Rob's is not password protected, so you could see what code he uses to
perform the magic.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DRYGUI" <(E-Mail Removed)> wrote in message
news:8859C263-4666-4C02-B2BB-(E-Mail Removed)...
> I've created some standard x,y,size bubble charts and want to add a forth
> variable to show color. Can someone show me how to do that in VBA? Also, I
> would like the bubble label to be in the fifth variable.

Hi jon,
I'm trying to do the same thing that Dry is doing. That is create a bubble
chart with a fourth variable to determine the color. Right now I have it set
up as follows:
Col1=Name; Col 2=X-Value, Col 3=Y Value; Col 4=Z-Value (Bubble Size);
Col5=Color (Color Value or Category name in my case)

Is there an easy way to do this with a macro or formula? Unfortuanlety I
don't know VB. Thanks!



"Jon Peltier" wrote:

> Turn on the macro recorder while you recolor individual bubbles, then adapt
> your code so it reads the cells and applies the appropriate color for that
> value.
>
> The bubble label can be added from the worksheet using a utility like this:
>
> Rob Bovey's Chart Labeler, http://appspro.com
> John Walkenbach's Chart Tools, http://j-walk.com
>
> Rob's is not password protected, so you could see what code he uses to
> perform the magic.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "DRYGUI" <(E-Mail Removed)> wrote in message
> news:8859C263-4666-4C02-B2BB-(E-Mail Removed)...
> > I've created some standard x,y,size bubble charts and want to add a forth
> > variable to show color. Can someone show me how to do that in VBA? Also, I
> > would like the bubble label to be in the fifth variable.
>
>
>