Types of Charts

The Cylinder, Cone, and Pyramid Charts

The Cone, Cylinder, and Pyramid charts can be used in the same scenario as the column and bar charts. Their 3-D visual effect can enhance the overall analysis of data. The Cylinder chart creates long circular boxes of the same base on both ends. It can be enhanced with good formatted Fill Effects. This chart is suitable for industry, manufacturing analysis, and predictions.

The cone is made of a circular base topped by a higher point. When used with various data, the higher values will have the complete cone while the lower values will share portion of the geometric figure. The cone chart should be used with values that can take advantage of its graphing dimensions.

The Pyramid chart resembles the cone chart with a difference on their respective base. Both are constructed the same and can be used in similar scenarios. When analyzing data for geographical purposes, the Pyramid chart can render very dramatic effects.

Practical Learning: Creating a Pyramid 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 and click Close
3. In the CustomersOrders list, double-click DayOfWeek
4. Run the query to preview it
5. Save the query as DailyCustomerAffluence and close it
6. To create a new chart, on the main menu, click Insert -> Form
7. In the New Form dialog box, click Chart Wizard and, in the bottom combo box, select DailyCustomerAffluence and click OK
8. In the first page of the Chart Wizard, click the select one button to add the DayOfWeek item to the Fields For Chart list and click Next
9. In the second page of the Chart Wizard, click the chart in the last column - 1st row Pyramid Column Chart 
10. Click Next twice
11. Set the Title to Daily Customer Affluence and click Finish
12. Save the form as chtDailyAffluence and print it
13. After viewing the chart, close its form