Automating bubble chart colours

[Guest]

Does anyone know if the colour of a bubble within a chart can be
conditionally formatted through reference to a cell within the spreadsheet ?

I want the colour of each bubble within the chart to based on the result of
a calculation within the spreadsheet. Currently the cells containing the
calculation are conditionally formatted to give a red, amber, green result
and I want to link the colour of the conditionally formatted cells to the
colour of the associate bubble.
(At the moment I update the bubbles manually)

 

[Andy Pope]

Hi,

The normal work around for making a charts formatting conditional is to
use multiple series. Then via formula only plot those points
(bubble/columns/markers/bars) that are valid.

See Jon's page for examples.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy

 

[Guest]

That's perfect, thank you Andy

Hi,

The normal work around for making a charts formatting conditional is to
use multiple series. Then via formula only plot those points
(bubble/columns/markers/bars) that are valid.

See Jon's page for examples.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Cheers
Andy