can i change plot area colors for different date ranges

if i want to shade the plot area of a chart diferent colors, for example gray
from Jan 1 through Fed 17, then white until March 10, is that possible? Will
want to change the shadinging preiodically and fairly frequently.

Thank you

Hi,

You should be able to use the technique explained on Jon's page
http://peltiertech.com/Excel/Charts/...ticalBand.html

Cheers
Andy

steve wrote:
> if i want to shade the plot area of a chart diferent colors, for example gray
> from Jan 1 through Fed 17, then white until March 10, is that possible? Will
> want to change the shadinging preiodically and fairly frequently.
>
> Thank you

--

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