Formatting Plot Area

[V Rocks]

I have a line graph with data that corresponds to dates. I want to format the plot area so that the fill color is different depending on the dates.

For instance 5/15 - 6/20 fill color light gray. For dates 6/21 - 6/30 fill color peach and for dates 7/1-7/30 fill color blue.

I can't seem to figure out if it is possible to do this. If anyone has any ideas I would really appreciate it!

Thanks!!

[Jon Peltier]

Perhaps you can modify the stacked area chart technique in this tutorial:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

You need three series, one for each color. The values for each are full
scale within its time range and zero elsewhere.

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


V Rocks wrote:

> I have a line graph with data that corresponds to dates. I want to
> format the plot area so that the fill color is different depending on
> the dates.
>
> For instance 5/15 - 6/20 fill color light gray. For dates 6/21 - 6/30
> fill color peach and for dates 7/1-7/30 fill color blue.
>
> I can't seem to figure out if it is possible to do this. If anyone has
> any ideas I would really appreciate it!
>
> Thanks!!
>
>

[V Rocks]

John -

Thanks for your help! I will give it a try.

-Joe