Conditional Formatting on Bubble Charts

[ijt70]

Is it possible to do conditional formatting on bubble charts? For example, if the size of the bubble is tied to a column named "Population", can the color of the bubble change for different ranges of populations?

I am using Excel 2000.

Thanks in advance.

 

[PaddyD]

Hi - welcome to the board!

Never tried it on bubble charts, but see here for an example of conditional formatting on bar charts.

http://www.geocities.com/jonpeltier/Excel/Charts/index.html#CondCht

Paddy