Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 11 Times Series 465

To open the Liquor workbook:

1 Open the Liquor workbook from the Chapter11 data folder.

2 Save the workbook as Liquor Sales Analysis. The workbook appears

as shown in Figure 11-22.

Figure 11-22
The Liquor
Sales Analysis
workbook

As a fi rst step in analyzing these data, create a line plot of sales versus year

and month.

To create a time series plot:

1 Select the range C1:D145 and click the Line button from the Charts

group on the Insert tab. Select the fi rst chart subtype (Line).

2 Move the chart to the chart sheet Sales Chart.

3 Enter the chart title Liquor Sales 1996–2007, enter Year for the

x-axis title, and enter Sales ($mil) for the y-axis title. Remove the

gridlines and legend from the plot.

4 Click the Axes button from the Axes group on the Layout tab of the

Chart Tools ribbon. Click Primary Horizontal Axis and then click

More Primary Horizontal Axis Options.