Graphing the Data in a Table

Overview

You can create a graph that is based on the data in the selected table by using the Graph tab to configure the type, content, and format of a graph that is based on the data in the selected table. You can display this tab in any context in which a table can be selected.

To create a graph, right-click a table, select Open, and click the Graph tab. Alternatively, from the desktop, click the Data Connections riser bar. Then, open a connection and select a table. Finally, click the Graph tab on the right.

Perform the following steps to create a graph from the data in the selected table:

1. Select a chart type in the drop-down list in the Chart Type field. The following types are available:
   • Column
   • Stacked Column
   • Bar
   • Stacked Bar
   • Pie
   • Line
   • Spline
   • Area
   • Bubble
   • Radar
2. Select a field for the X Axis field.
3. Select a field for the Y Axis field.
4. Select a field for the Z Axis field (if applicable for the chart type).
5. Set the Row count range.
6. Select 3D if you need to generate the graph in three dimensions.