Share via


Bar Charts (Report Builder)

A bar chart displays comparisons among individual items. The series is displayed 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 compares values across categories. The series are displayed as individual bars, 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 the relationship of individual items to the whole. All series values are 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 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 compares the percentage each value contributes to a total across categories. All series values are 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

Tasks

How to: Create a New Report (Report Builder)

Concepts

Working with Report Layouts (Report Builder)
Changing the Appearance of a Chart (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance