If a table does not contain column percentages, the chart is based on the counts, as shown in this example. For charts that do not contain either column percentages or counts, the charts are based on the first cell item. A chart is not created for any tables that contain cell prefixes in the column percentage cells. Base elements are omitted from the charts.

By default, chart series are based on the table rows. You can base the chart series on table columns by clearing Chart table rows as series in the Export dialog.

For concatenated and nested tables, a separate chart is created for each section of the table. For example, the following diagrams show the charts that are created for a concatenated and a nested table.

Here is the concatenated table:

Here is the nested table:

You can create charts for statistical elements, such as elements that show the mean, minimum value, standard deviation, and so on. If more than one such element is included in the table specification, or if the table includes a mixture of categorical and other elements, a separate chart is created for each statistical element in the table. For example, a separate chart would be produced for each statistical element in the table shown in Adding summary statistics to a numeric variable. A chart is also produced when a numeric variable is banded. For example, a chart would be produced for the table shown in Banding a numeric variable.

When you export charts to Excel, PowerPoint, or Word, you can optionally export the charts to a user-defined custom chart type that you have set up using Excel. For more information, see Exporting charts using Microsoft Excel custom chart types.