Sunday, February 03, 2008
Charting Economic Time Series with Shaded Recessions
If you read the business press or government economic reports, then you have undoubtedly seen charts that show recessionary periods with shading. In this post I will demonstrate how to create this type of chart in Excel 2007. The same technique is applicable to all versions of Excel, though the mechanics of creating the charts in earlier versions are slightly different. Users of other spreadsheets, such as Open Office Calc should be able to use a similar procedure.
Obviously, if we are to chart an economic data series and shade the recessions then we need data. For this post I will be
Posted by Tim on 02/03 at 06:46 PM in
Charts
in
Dates
in
Economic Data
in
Excel
in
Excel 2007
in
Functions
in
And
in
Index
in
Match
Comments (5) • Permalink • Tell-a-Friend
Comments (5) • Permalink • Tell-a-Friend
Page 1 of 1 pages
