Hi,

Not quite sure want your definition of background is in your particular
chart. If it is the circular area inside the dial then you could add
more rings to the donut chart.

Cheers
Andy

Kyle wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info