can i change plot area colors for different date ranges

[steve]

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]

Hi,

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

Cheers
Andy