Populate the Simple Pie Chart item to Meet the Business Requirements
next steps might focus upon simply dragging fields from the Fields pane
of the Report Designer, we will populate our chart from inside the
multi-tabbed Chart Properties dialog. Because few charts I encounter in
the business environment can be built completely through the drag-and-drop
process anyway (expressions are often involved in combination with the date
fields, as an example), I long ago developed the habit of working from the Properties
dialog. (The practice of tabbing through the Properties dialog can
often remind us of other settings we need to make, additional options that are
available in meeting client / employer needs, and so forth, as an another
the generic chart item.
from the context menu that appears, as shown in Illustration 11.
Illustration 11: Select Properties from the Context Menu
The Properties dialog appears, defaulted to the General
tab, where we will begin our examination of the chart properties in the subsections
following into the Title box on the General tab:
Sales Reason Comparisons
Style button, depicted (and also magnified) within the respective red
squares in Illustration 12, to the immediate right of the Title
Illustration 12: Click the Style Button for the Title Box ...
Properties dialog box appears.
settings, listed in Table 1 below, within the Style Properties
Table 1: Style Properties Dialog
Properties dialog appears, with our settings, as shown in Illustration 13.
Illustration 13: Style Properties Dialog Box with Settings
to accept changes and to exit the Style Properties dialog box.
to the General tab.
in the Chart type selection list.
the left-most selection, Pie chart (the simple versus the exploded Pie
chart) is highlighted, among the context-sensitive Chart sub-type
selections to the immediate right of the Chart type selection list.
Click the Chart
Area Style... button, which appears in the bottom left corner of the General
manipulate settings for chart borders and lines via the Borders and Lines
tab, depicted with default settings in Illustration 14.
Illustration 14: Style Properties Dialog Box Border and Line Tab (with Default Settings)
Click the Fill
tab to expose the chart Fill settings, which appear (with defaults)
as shown in Illustration 15.
Illustration 15: Style Properties Dialog Box Fill Tab (with Default Settings)
OK button at the bottom of the Style Properties... dialog, to dismiss
the dialog with all properties settings at default.
to the General tab, once again.
Plot Area Style... button, which appears to the immediate right of the Chart
Area Style... button at the bottom of the General tab.
two-tabbed Style Properties dialog that appears is identical to that
which we saw when we clicked the Chart Area Style... button in the
immediately preceding steps. Since we will be leaving these settings, too, at
their defaults, we will dismiss the Style Properties dialog at this
OK button at the bottom of the Style Properties dialog, to dismiss
the dialog with all properties settings at default.
to the General tab, once again, which appears, with our settings, as
depicted in Illustration 16.
Illustration 16: Chart Properties Dialog Box General Tab with Our Settings
move to the Data tab in the subsection that follows.
Click the Data
downward pointing arrow on the right side of the Dataset name box atop
the Data tab, display and select the ProductData dataset, as
shown in Illustration 17.
Illustration 17: Select the ProductData Dataset ...
Click the Add...
button to the right of the Values list box, found immediately underneath
the Dataset name selector we populated above.
The values in a Value series determine the size of the
slice in the Pie. Multiple Value series appear as separate
slices. If we have multiple Category or Series groups, the group
labels are displayed in the chart legend.
Chart Value dialog appears, defaulted to the Values tab.
following into the Series label box, atop the Values tab:
Click the function
(fx) button to the right of the Value box, depicted within
a circle in Illustration 18.
Illustration 18: Click the Function Button for the Value Box ...
Click the Fields
(ProductData) option in the bottom left corner pane of the Expression
values of the ProductData dataset appear within the pane in the bottom
right corner of the Expression Editor.
to place this selection into the main pane atop the Expression Editor.
Editor appears, with our input, as shown in Illustration 19.
Illustration 19: The Expression Editor with Our Input ...
Click OK to
accept our input and to dismiss the Expression Editor.
returned to the Edit Chart Value dialog, which appears with our input as
depicted in Illustration 20.
Illustration 20: The Edit Chart Value Dialog, with Our Input...
Click the Appearance
tab on the Edit Chart Value dialog.
Click the Series
Style... button in the lower left corner of the Appearance tab.
tabbed Style Properties dialog appears again, just as it did
for the Chart Area Style... and Plot Area Style... buttons we
examined earlier. We see the same Border and Line and Fill tabs,
which we will leave at default at this point.
to dismiss the Style Properties dialog, and to return to the Appearance
tab of the Edit Chart Value dialog.
Click the Point
Labels tab on the Edit Chart Value dialog.
check box to the immediate left of Show point labels atop the Point
downward pointing arrow to the right of the Data label box to display
data selection options.
from the options, as shown in Illustration 21.
Illustration 21: Select =Fields!Internet_Sales_Amount.Value as the Data Label ...
Within the Format
code box (just underneath the Data label selector) type the
following character pattern:
Uncheck the Auto
checkbox to the right of the Format code box.
result in the point labels being displayed outside the Pie, at an
angle to a connecting line, making the chart more compact and, in this case,
making the labels themselves somewhat easier to read.