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
Using Excel
Getting Acquainted with Visual Basic for Applications
Collecting and Cleaning Up Data
Charting
Statistical Analysis
Time Series Analysis
Mathematical Functions
Curve Fitting and Regression
Solving Equations
Numerical Integration and Differentiation
Solving Ordinary Differential Equations
Solving Partial Differential Equations
Performing Optimization Analyses in Excel
Introduction to Financial Calculations
Index