combining different excel charts

[rkizik]

Hi,

I have an economic time series that I've graphed using a line chart.
Our professor wants us to add recessions to this chart. Is there a wa
adding a bar chart to a line chart?

I just drew vertical lines between the dates in question and adde
diagonals but the graph looks amateurish. Ideally, I'd like to be abl
to add a shaded column between the dates but still have the line sho
through the shaded area.

Thanks.

Bo

 

[Andy Pope]

Hi,

Have a look at Jon Peltier's example of vertical banding,
http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html

Cheers
Andy