Column Charts

A column chart displays values and series groups as sets of vertical columns that are grouped by category. Values are represented by the height of the columns as measured by the y-axis. Category labels are displayed on the x-axis. Column charts are typically used to compare values between categories.

There are three types of column charts: column, stacked column, and 100% stacked column.

Column

A column chart displays series as individual columns, grouped by category. The height of each column is determined by the series value.

Chart area Description

Values

Required. The values in a value series determine the height of the columns in that series. Value labels appear on the y-axis. Each value series appears as individual columns.

Category groups

Optional. Categories are displayed as columns or groups of columns on the x-axis. Multiple groups are nested.

Series groups

Optional. Series are displayed as individual columns in the chart. Each series is also displayed in the chart legend.

Stacked Column

A stacked column chart displays all series stacked in a single column for each category. The height of each column is determined by the total of all series values for the category.

Chart area Description

Values

Required. The values in a value series determine the size of that series in the column. Value labels appear on the y-axis. Each value series appears as a section within the column.

Category groups

Optional. Categories are displayed as columns on the x-axis. Multiple groups are nested.

Series groups

Optional. Series are displayed as sections within columns in the chart. Each series also is displayed in the chart legend.

100% Stacked Column

A 100% stacked column chart displays all series stacked in a single column for each category. The height of each column is always the full height of the chart. The series values are displayed as percentages of each column.

Chart area Description

Values

Required. The values in a value series are used to determine the percentage of the whole. This percentage determines the size of the series in the column. The y-axis shows a value of 0 to 100. Each value series appears as a section within the column.

Category groups

Optional. Categories are displayed as columns on the x-axis. Multiple groups are nested.

Series groups

Optional. Series are displayed as sections within columns in the chart. Each series also is displayed in the chart legend.

Hybrid Column/Line Charts

You can also create a chart that combines both columns and lines in a single chart. To do this, you create a column chart with multiple value series, then set the PlotType property on one or more of the value series to display that value series as a line.

To view instructions about creating a hybrid column/line chart and setting the PlotType property, see How to: Create a Column/Line Chart (Report Designer).

See Also

Concepts

Working with Chart Data Regions

Help and Information

Getting SQL Server 2005 Assistance