Different background color depending on x-axis value
 

Hi!

Is there any way to have the background in a chart have different
colors depending on x-axis values?

Like
x-axis value 1-10 = blue background
x-axis value 10-20 = red background

Thanks


--
RealRaven
------------------------------------------------------------------------
RealRaven's Profile: http://www.excelforum.com/member.php...o&userid=37058
View this thread: http://www.excelforum.com/showthread...hreadid=567788

Different background color depending on x-axis value
 

Here are a few of the ways you can get custom background fills for your
charts"

http://PeltierTech.com/Excel/Charts/...tml#Background

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"RealRaven" wrote
in message ...

Hi!

Is there any way to have the background in a chart have different
colors depending on x-axis values?

Like
x-axis value 1-10 = blue background
x-axis value 10-20 = red background

Thanks


--
RealRaven

Different background color depending on x-axis value
 

Amazing, it looks really great. Weird that I have to fool excel into
doing this, feels like something they (m$) would like us to be able to
do :)

Thanks.


--
RealRaven
------------------------------------------------------------------------
RealRaven's Profile: http://www.excelforum.com/member.php...o&userid=37058
View this thread: http://www.excelforum.com/showthread...hreadid=567788