This task adds data items to the data deck and
to the pie chart.
Procedure
- Click the Source tab
and drag
the following data item to the Values box of
the data deck: Sales (query) > Products > Product
line
- Drag the following data items to the chart:
- Sales (query) > Sales > Quantity to
the Default measure box.
- Sales (query) > Products > Product
line to the Series (pie slices) box.
- Sales (query) > Retailers > Region to
the Categories (pies) box.
- With the pie chart selected, in the Properties pane,
click the Exploded Slices property and do the
following:
- Select the default value and click the Delete icon
.
- Click the New icon
.
- Change Exploded amount to 25.
- In the Exploded slice section,
click Expression and then click the ellipsis.
- In the Expression Definition box,
type the following, and click OK three times.
[Query3].[Product line]=[Query4].[Product line]
- In the Properties pane, click the Clickable
Regions property, select the Legend Labels check
box, and click OK.
By default,
the Intersections check box is selected. By
making the legend labels clickable, users will be able to click different
pie slices in the chart or different product lines in the legend.
- Optional: If you do not want to use the pie
chart default colors, specify the colors that you want by clicking
the available properties in the Color & Background property
group.
For example, you can change the color palette
for the chart by clicking the Palette property.
