Book contents
- Frontmatter
- Dedication
- Contents
- Preface
- Software Requirements and Opening a Macro-Enhanced Workbook
- Introduction:Why Simulation and Excel?
- 1 Charting in Excel
- 1.1 Introduction
- 1.2 Simple Scatterplot and Double Y Charts: HowToChart.xls
- 1.3 The Shaded (Recession) Chart: RecessionChart.xls and EconChart.xla
- 1.4 Summary
- 2 Economic Growth Literacy
- 3 The Solow Model
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- References
1.3 - The Shaded (Recession) Chart: RecessionChart.xls and EconChart.xla
from 1 - Charting in Excel
Published online by Cambridge University Press: 05 May 2016
- Frontmatter
- Dedication
- Contents
- Preface
- Software Requirements and Opening a Macro-Enhanced Workbook
- Introduction:Why Simulation and Excel?
- 1 Charting in Excel
- 1.1 Introduction
- 1.2 Simple Scatterplot and Double Y Charts: HowToChart.xls
- 1.3 The Shaded (Recession) Chart: RecessionChart.xls and EconChart.xla
- 1.4 Summary
- 2 Economic Growth Literacy
- 3 The Solow Model
- 4 Macro Data with FRED in Excel
- 5 The Keynesian Model
- References
Summary
(i). A strongly good graph shows us everything we need to know just by looking at it.
(ii). A weakly good graph shows us everything we need to know just by looking at it, once we know how to look.
– Howard WainerQuick Summary
To access RecessionChart.xls, visit:
http://www.depauw.edu/learn/macroexcel/excelworkbooks/Charting/RecessionChart.xls
RecessionChart.xls uses real crude oil price data to demonstrate how to use the Econ Chart Enhancer add-in to create a time series with shaded bars based on U.S. recessions. It also uses World Top Incomes data to replicate a chart on U.S. income inequality with shaded bars when the top 10% earn 45% or more of total income. Proficiency with basic charting in Excel is required.
The Econ Chart Enhancer add-in, filename EconChart.xla, available at http://www.depauw.edu/learn/macroexcel/exceladdins, enables enhancements to an existing chart, such as natural log scale (not merely Excel's base 10 log scale) and easily adding shaded bars for recession (or other) time periods. Download the add-in from the website and use the Add-Ins Manager to install it.
Screencasts
• http://vimeo.com/econexcel/howtoinstallexceladdin: shows how to install an add-in Excel via the Add-Ins Manager
• http://vimeo.com/econexcel/realcrudeoilpricechart: charts real crude oil price over time
• http://vimeo.com/econexcel/addrecessionbars: use the Econ Chart add-in to add recession bars to real crude oil price chart
• http://vimeo.com/econexcel/shadedbarswhenpricefalls: more practice with the Econ Chart add-in
• http://vimeo.com/econexcel/shadedbarsapplication: use the Econ Chart add-in to replicate a chart on income inequality
Introduction
Plotting a time series with shaded bars for recessionary periods has become a staple in financial literature. It is an effective way to show a second variable, such as the performance of the economy, while displaying more detail about a primary variable of interest. Unfortunately, it is not easy to create such a chart. Excel, however, can be tricked into doing it, and the complicated steps have been packaged into the Econ Chart add-in so the user can quickly add shaded areas to any chart.
Common Problems for Students
Installing the add-in requires use of the Add-Ins Manager. Students sometimes ignore all instructions and attempt simply to open the add-in file as if it were a conventional Excel workbook.
- Type
- Chapter
- Information
- Teaching Macroeconomics with Microsoft Excel® , pp. 19 - 24Publisher: Cambridge University PressPrint publication year: 2016