Types of Charts

Multi-Series Charts

In some cases you may want to analyze two or more series of data, either concurrently or as they relate to each other. For example, in our ice cream application, you may want to know how often customers who order the Butter Pecan flavor are likely to add an ingredient to their order (since butter pecan already has some nuts in it). Also, if another analysis reveals that Vanilla is most often ordered, is it related to a particular time of the day?

To analyze data from two series, when preparing it, make sure you create a way for the chart engine to figure out how to reconcile the numbers. Also, not all charts are made for multiple series.

Practical Learning: Creating a Multi-Series Chart

1. To create a new query, on the main menu, click Insert -> Query and, in the New Query dialog box, double-click Design View
2. In the Show Table dialog box, double-click CustomersOrders followed by Containers and click the Close button
3. In the CustomersOrders list, double-click PeriodOfDay 
4. In the Containers list, double-click Container
5. To view the result, switch the query to Datasheet View
6. Save the query as ContainerByPeriodOfDay and close it
7. On the main menu, click Insert -> Form
8. In the New Form dialog box, click Chart Wizard and, in the bottom combo box, select ContainerByPeriodOfDay, and click OK
9. In the first page of the Chart Wizard, click the select all button to add both fields to the Fields For Chart list and click Next
10. In the second page of the Chart Wizard, click the chart in the 2nd column - 1st row Pie Chart
     
11. Click Next twice
12. Set the Title to Container by Period of Day and press Enter
13. After viewing the chart, save the form as chtContainerByPeriodOfDay
14. Print the form and close it