How do I change only part of the background in a chart Excel 07

I need at set vertical intervals in the background for a bar chart different
colors as values increase incrementally on the Y axis. How do I do that and
avoid having the background behind the bars NOT be just one color?
Thanks,

Hi,

Have a look at Jon's page on colour banding,
http://peltiertech.com/Excel/Charts...HorizBands.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Lonny" <Lonny@discussions.microsoft.com> wrote in message
news:B7DEE143-5F70-4986-A3B3-0ACF969C5802@microsoft.com...
>I need at set vertical intervals in the background for a bar chart
>different
> colors as values increase incrementally on the Y axis. How do I do that
> and
> avoid having the background behind the bars NOT be just one color?
> Thanks,
>

Thanks for the helpful information!

"Andy Pope" wrote:

> Hi,
>
> Have a look at Jon's page on colour banding,
> http://peltiertech.com/Excel/Charts...HorizBands.html
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Lonny" <Lonny@discussions.microsoft.com> wrote in message
> news:B7DEE143-5F70-4986-A3B3-0ACF969C5802@microsoft.com...
> >I need at set vertical intervals in the background for a bar chart
> >different
> > colors as values increase incrementally on the Y axis. How do I do that
> > and
> > avoid having the background behind the bars NOT be just one color?
> > Thanks,
> >
>