PreviousNext

Chart Types

By default, charts are clustered column charts based on column percentages. You can also choose from the chart types below. Click a link below to display an example chart and description. To hide the example, click the link again.

Clustered Bar Clustered Bar

Compares values across categories

Stacked Bar Stacked Bar

Compares the contribution of each value to a total across categories

3D Clustered Bar 3D Clustered Bar

Clustered Bar with a three-dimensional visual effect

3D Stacked Bar 3D Stacked Bar

Stacked Bar with a three-dimensional visual effect

Clustered Column Clustered Column

Compares values across categories. This is the default chart type.

Stacked Column Stacked Column

Compares the contribution of each value to a total across categories

3D Clustered Column 3D Clustered Column

Clustered Column with a three-dimensional visual effect

3D Stacked Column 3D Stacked Column

Stacked Column with a three-dimensional visual effect

3D Column 3D Column

Compares values across categories and across series

Line Line

Displays trend over time or categories

Stacked Line Stacked Line

Displays the trend of the contribution of each value over time or categories

Line with Markers Line with Markers

Line with markers displayed at each data value

100% Stacked Line with Markers 100% Stacked Line with Markers

Displays the trend of the percentage each value contributes over time or categories, with markers displayed at each data value

Pie Pie

Displays the contribution of each value to a total. Note that Pie charts are not generated if you only have a variable on the side axis. You must have a variable on the top axis or both axes.

3D Pie 3D Pie

Pie with a three-dimensional visual effect. Note that 3D Pie charts are not generated if you only have a variable on the side axis. You must have a variable on the top axis or both axes.

Separated Pie Separated Pie

Displays the contribution of each value to a total while emphasizing individual values. Also known as Exploded Pie. Note that Separated Pie charts are not generated if you only have a variable on the side axis. You must have a variable on the top axis or both axes.

3D Separated Pie 3D Separated Pie

Separated Pie with a three-dimensional visual effect. Also known as 3D Exploded Pie. Note that 3D Separated Pie charts are not generated if you only have a variable on the side axis. You must have a variable on the top axis or both axes.

You can select a chart type for an individual table using the Chart tab in the Table Properties dialog box. If you do not specify a chart type, the default chart type is used (this depends on the type of table, but in most cases is a Clustered Bar chart). When you export your results, you can select a chart type to use for the export. This becomes the default chart type for any tables for which no chart type is specified. It does not override chart types you have selected for individual tables using the Chart tab.

When you export charts to Microsoft Excel, PowerPoint, or Word, you can optionally export the charts to a user-defined custom chart type that you have set up using Excel. See the topic Exporting Charts Using Microsoft Excel Custom Chart Types for more information.