Advanced Report Design - Professional SQL Server 2005 Reporting Services - page 234

Figure 6-68
Figure 6-69
Pie charts are traditionally used to show multiple slices representing their data point percentage of the
whole. In the usual form, data values grouped on another axis will result in slices automatically gener-
ated with the same style settings and contrasting colors from a standard color pallet. There are eight
color pallets provided in the designer. Sometimes data may need to be presented as a percentage value
or you may simply have two values and need to express one as a percentage of the other. This is possible
by adding multiple Value groups to the chart with each representing a specific slice. In Figure 6-70 , only
two values are presented. In this example, values in the data set exist for Bike Sales and Total Sales. Using
an expression or a calculation in the query, subtracting Bike Sales from the total provides a value for
Other Sales.
As you can see in Figure 6-71, I created a specific group for these two values. Another advantage of
using this approach is that I can set the color and styles for each slice independently. You'll take a closer
look at this and similar techniques in Chapter 7.