Conditional Format A Bubble Chart

**Delaware** · 03-17-2010, 03:43 PM

I am attempting to provide conditional formatting for a bubble graph in which the color of the bubble will bet set depending upon certain criteria. I wish to provide formatting without having to go down the VBA path.

<5 - Red
Between 5 and 10 - Yellow
>10 - Green

**Andy Pope** · 03-18-2010, 07:47 AM

Use multiple series, one for each colour.
Use formula to populate each series with the correct values or NA() function.

Search forum for Conditional charts or post example if you need more help.

**Delaware** · 03-18-2010, 09:43 AM

Many thanks for the reply. I am currently utilizing IF/NA() formulas for each of the colors. The problem I am dealing with is that the buckets and numbers are not static. The user will populate a wide range of potential numbers/percents.

Any thoughts??