|
Homework Assignment 5a:
OLD ASSIGNMENT DO NOT USE
In-class exercise: Time Series Charts
Standards for time series charts:
-
minimize the ink-to-data ratio
-
Clearly distinguish between lines
representing different series.
-
beware of scaling distortions.
-
always display time on the X-axis,
left to right.
Task: Create a Time series chart that
looks like this:
Download the Excel file with the data here
Characteristics of chart:
-
a single data series defines the oil prices
-
this is a line chart
-
An extra data series is used to label the data point on
the line
-
the Y-axis is on the right
-
to format the title as shown, a text box --not a chart
title --is used.
(use Insert | Textbox)
Things you have to do:
Set up label "Bush approves..":
-
Select chart, then:
Chartools | Design | Select data (select the label series) | Hidden
cells | connect points with line
-
Format "label" data series
Format X-axis:
Format Y-axis:
| 