POS 138 Quantitative Reasoning in Political Science

Home Up

Lab 7: Formatting a Time Series Chart  (this is to be done before HW7)

Read JPDA Voting and Elections (especially pp86ff)
Times series chart tips

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.

  • use data labels rather than legends

Prepare a chart, using these data, that looks like this (or better).

Features of Chart:

  • small size: 2.5H x 4.0 W

  • Y axis on the right side (done when formatting the X axis)

  • No legend --datapoint data labels

  • Chart title (and source) is a textbox (not a title) --  use Insert | Textbox

  • format line color, chart area light blue; plot area light orange