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" wrote in message
...
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.