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
Figure 6-1. Time series chart