Plotting Time Series Data

Problem

You need to plot a set of time series data for further analysis.

Solution

Time series charts, such as the one shown in Figure 6-1, are easy to create in Excel.

Select the data series (both x and y values) you want to chart and then press the Chart Wizard button on the Standard toolbar, or select Insert images/U2192.jpg border=0> Chart... from the main menu bar to open the Chart Wizard. The Chart Wizard allows you to select the chart style and customize charts in various ways. Read Chapter 4 to learn more about creating charts in Excel.

Figure 6-1. Time series chart

Категории