Pie Charts (Report Builder)

A pie chart shows the size of items that make up a data series, proportional to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element in the data or show the relationship of parts to the whole. A pie chart displays value data as percentages of the whole. Categories are represented by individual slices. The size of the slice is determined by the value. Pie charts are typically used to show percentages.

There are two types of pie charts: pie and exploded pie.

Pie

A pie chart displays the contribution of each value to a total. The category groups, series groups, and values are displayed as pie slices. The size of the slice is determined by the series value as a percentage of the total of all values.

Chart area Description

Values

Required. The values in a value series determine the size of the slice in the pie. Multiple value series appear as separate slices.

Category groups

Optional. Categories are displayed as individual slices in the pie. Each category is displayed in the chart legend.

Series groups

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

Settings for the x- and y-axis are ignored for pie charts. If you have multiple category or series groups, the group labels are displayed in the chart legend.

Exploded Pie

An exploded pie chart displays the contribution of each value to a total while emphasizing individual values. It is identical to a pie chart except that the slices are moved away from the center of the pie. This results in space between the pie slices.

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