different colors based on cell values in bubble graphs

[Nassa Nassa]

I have a bubble graph and I want to change the color of bubbles based on cells values in the following condition:

Cell<= 18 --> Red
Cell>18 --> Green

thank you.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Calender Popup
http://www.eggheadcafe.com/tutorials/aspnet/29105211-d861-4f2e-ba87-fe41a994760a/calender-popup.aspx

 

[JB]

http://boisgontierjacques.free.fr/fichiers/GrapheBulleMacro.xls

JB
http://boisgontierjacques.free.fr

 

[Herbert Seidenberg]

Excel 2007
Conditionally color, name bubbles.
With macro, in English.
http://www.mediafire.com/file/gtzmymnmmzn/01_11_10.xlsm