howdy,

I'm trying to setup a chart in excel that conditionally formats the
background colour.
I'm already using the speedometer chart
(http://peltiertech.com/Excel/Charts/Speedometer.html)
and need to conditionally format the background to be different colours such
as red, yellow or green.

To make it even more fun, I'm trying to format it with a fill effect to make
it look a lot better.

Currently I've just generated 3 versions of the same chart and just cut and
pasted the one I need each week, but this has become quite time consuming and
I'd like to find a way to automatically just set the background colour
depending on a cell value in the sheet.

Is there a way to do this? I've read many of the conditional formatting
websites linked to from here such as
http://peltiertech.com/Excel/Charts/...html#CondChart
and
http://peltiertech.com/Excel/Charts/...tml#CondChart2
but they both deal with using the secondary chart to fake the background.
As the speedometer chart already uses the secondary axies, I am unable to use
this type of trick.

your help is greatly appreciated.