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

can i change plot area colors for different date ranges
 

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