Background Color Code Sections

[Guest]

I have 7 different major sections (years) on the x axis of a bar graph. Is it
possible to have the backround/plot area (not the bars) colored in 7
different shades? Help is appreciated!

 

[Jon Peltier]

Use a set of area chart series on the primary axes, using a technique like
this:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

Then add new series for the bars. When you first add a new series it will
not be the type you want, so change it to the bar or column (or whatever
else) you want. You will probably also want it on the secondary axes.

You can hide the primary axes and rearrange the other axes so the chart
looks like you want it.

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