You need to plot a set of time series data for further analysis.
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
Getting Acquainted with Visual Basic for Applications
Collecting and Cleaning Up Data
Time Series Analysis
Curve Fitting and Regression
Numerical Integration and Differentiation
Solving Ordinary Differential Equations
Solving Partial Differential Equations
Performing Optimization Analyses in Excel
Introduction to Financial Calculations