economic chart

[Guest]

How do I make a chart combining company informmation with economic data,
specifically USA recessions. The line representing monthly sales (or
economic activity) and one or morel lightly shaded vertical bars, each
spanning several months and stretching from the bottom to the top of the
chart, representing one or more recessions.

THANKS!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...eab0ea76a0&dg=microsoft.public.excel.charting

 

[Bernard Liengme]

This is a very broad question. Why not try that magic thing call a book?
Then when you get specific we can help.
best wishes

 

[Guest]

Specifically, I have monthly data for the NAPM-Chicago Business Barometer(tm)
from 1970 through 2005 (values 0-100). I would like to add to the line plot
the following vertical bars representing recessions:
Nov 73 - Mar 75
Jan 80 - Jul 80
Jul 81 - Nov 82
Jul 90 - Mar 91
Mar 01 - Nov 01
Thanks
Jack