The next step is to create a line chart for each Sales Territory. The chart will display a line for each employee, the y axis will be the
total sales for the employee, and the x axis will be the fiscal quarter.
1.
Right click in the white space in the Group Header #1 section.
2.
Select InsertàChart… from the
pop-up menu.
3.
The Chart Expert dialog will appear. Change the Chart Type to Line.
4.
There are six different types of line charts. Click the button for the line
chart on the bottom left. This will display a line and a marker at the data
points.
Figure 10
5.
Click the Data tab.
6.
Change the Place Chart drop down list to Once for each
SalesTerritory.Name.
7.
Click on the FiscalQuarter field in the Available Fields list and click
the > button to move this field to the On Change Of list box.
8.
Click on the EmployeeName field in the Available Fields list and click
the > button to move this field to the On Change Of list box.
9.
Click the SalesOrderHeader.SubTotal field in the Available Fields list
and click the > button to move this field to the Show Values list.
Figure 11
10. Click
on the Text tab.
11. Uncheck
the Auto Text for the Title. Change the Title to Total Sales By Employee.
12. Uncheck
the Auto Text for the Group title. Change the Group title to Order Date.
13. Uncheck
the Auto Text for the Data title. Change the Data title to Sales.
14. Click
the OK button.
The Group Header #1 section will now be divided in two with
the chart being in the top part and the cross tab in the bottom. Expand the
width of the chart to the width of the page.
Figure 12
