Share via


Bar Charts

A bar chart displays series as sets of horizontal bars that are grouped by category. Values are represented by the length of the bars as measured by the x-axis. Category labels are displayed on the y-axis. Bar charts are typically used to compare values between categories.

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

Bar

A bar chart displays series as individual bar, grouped by category. The width of each bar is determined by the series value.

Chart area Description

Values

Required. The values in a value series determine the width of the bars in that series. Value labels appear on the x-axis. Each value series appears as individual bars.

Category groups

Optional. Categories are displayed as bars or groups of bars on the y-axis. Multiple groups are nested.

Series groups

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

Stacked Bar

A stacked bar chart displays all series stacked in a single bar for each category. The width of each bar 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 the of that series in the bar. Value labels appear on the x-axis. Each value series appears as a section within the bar.

Category groups

Optional. Categories are displayed as bar on the y-axis. Multiple groups are nested.

Series groups

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

100% Stacked Bar

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

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 bar. The x-axis shows a value of 0 to 100. Each value series appears as a section within the bar.

Category groups

Optional. Categories are displayed as bars on the y-axis. Multiple groups are nested.

Series groups

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

See Also

Concepts

Working with Chart Data Regions

Help and Information

Getting SQL Server 2005 Assistance