Help on displaying recession periods in a financial/ stock chart

[Guest]

Using excel version (10.6501.6626)sp3

How do you shade the chart background to show economic recession periods in a financial/ stock chart. I've fiddled with the drawing function-rectangle box, transparency, etc- but it isn't very satisfactory since it corrupts the column/ line colors and usually washes out when printed. So that doesn't appear to be the solution. And after checking thru Microsoft help and the discussion group messages I haven't found a message addressing my problem. Since we see charts all the time with the recession periods shown I know there is a way to accomplish it; but it's defeated me! Thanks.

 

[Jon Peltier]

Here's an old one I just dusted off. It describes making a gray
background for weekends in a stock chart. You can apply the same
technique to your chart.

http://www.google.com/[email protected]

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