Excel - inflation column Select “Format Cells” Here we change the decimal points appearing Notice how all those decimals are gone … and

Info iconThis preview shows pages 1–37. Sign up to view the full content.

View Full Document Right Arrow Icon
Here is an example: a direct download from the St. Louis Fed, FRED database
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Enter your formula, starting with =
Background image of page 2
Here is the result!
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Use CRT+C to copy, select the area where you want to copy the formula, then use CRTL+V to paste. Notice how the formulas are tailored to the cells!
Background image of page 4
Select the data that you want to plot
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Select a 2 D line graph
Background image of page 6
See the graph appear on top your spreadsheet
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Let’s move the graph to a new sheet
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
Let’s add the dates
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Select the horizontal edit button
Background image of page 12
We will need to direct EXCEL to load the data from the sheet with the data
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Here I select the column with the dates. Starting with the first observation of the inflation series, not the original data
Background image of page 14
Notice dates appear on the horizontal axis
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Let’s change the label of Series 1 to “Inflation”
Background image of page 16
Background image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 18
Background image of page 19

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Let’s changes the units of inflation so that only one decimal point shows up. Select the
Background image of page 20
Background image of page 21

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 22
Background image of page 23

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 24
Background image of page 25

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 26
Background image of page 27

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 28
Background image of page 29

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 30
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: inflation column. Select “Format Cells” Here we change the decimal points appearing Notice how all those decimals are gone! … and notice how the vertical axis now looks much better! Now let’s fix the horizontal axis so that we can read the dates better Here we change the frequency with which dates are displayed Notice now dates appear only every 4 years To get rid of a feature of the graph just click on it and then press delete. Here I get rid of the gridlines They are gone! Let’s change the title of the graph Either by right ‐ clicking (or sometimes having the mouse hover over the title) you will bring the font menu up Let’s Increase the font There you go Of course, same can be done with the axis themselves...
View Full Document

This note was uploaded on 10/08/2009 for the course ECON ECN101 taught by Professor Pontusrendahl during the Spring '09 term at UC Davis.

Page1 / 37

Excel - inflation column Select “Format Cells” Here we change the decimal points appearing Notice how all those decimals are gone … and

This preview shows document pages 1 - 37. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online