Using the Palette
dropdown selector, choose Semi-Transparent.
under Chart Type in the lower left corner of the General tab.
the leftmost of the two Chart sub-types is selected.
Click the Data
tab to select it.
in the Dataset name box.
click Edit, to the right of the Values box.
Chart Value dialog box appears.
Click the Point
Labels tab to select it.
place a checkmark, in the checkbox to the left of Show point labels.
Click the Expression
button (pictured in Illustration 19) to the immediate right of the Data
label selector box.
The Expression Button
Expression dialog box appears.
following into the Expression area:
=Fields!StateCode.Value & vbcrlf & "(" &
CSTR(Count(Fields!VendorID.Value)) & ")"
Expression dialog appears as shown in Illustration 20.
20: The Edit Expression Dialog with our Input
in the expression above, we are leveraging the data label to perform two
functions: First, we are generating a State abbreviation (recall we are
focusing on Washington, California, and Oregon) to
label the sections of the chart. Second, we are adding a count of vendors
within each respective section. The delivery of this data is, in effect, adding
another conceptual dimension to the information we are imparting.
We used "&"
in the expression to concatenate each State abbreviation (always
separate the "&" character from others by a single space
on both sides) with the respective count of the vendors within each,
adding a line break (via the old carriage return-line feed keyword, vbcrlf,
) to separate the two. (Using vbcrlf in this manner is a great way to
make what would normally appear on a single line separate into two or more
to accept input.
Expression dialog box closes, returning us to the Point Labels tab.
Click the Label
Style button in the lower left section of the Point Labels tab.
The Style Properties dialog box appears.
Make the settings,
listed in Table 2 below, within the Style Properties dialog box:
Table 2: Style Properties Dialog
Properties dialog appears, with our settings, as depicted in Illustration
21: Style Properties Dialog Box with Settings
to accept settings.
Properties box closes. We return to the Edit Chart Value dialog box,
which now appears as shown in Illustration 22.
22: The Edit Chart Value Dialog Box
to close the Edit Chart Value dialog.
to the Chart Properties dialog box, Data tab.
Click the Legend
tab to select it.
shall see, our design will alleviate the need for a legend of the garden
variety. Our expression in the Data Label above causes the placement of
a label directly upon each section of the chart.
tab appears, with our settings, as depicted in Illustration 23.
21: Legend Tab with Settings
Click the 3-D
Effect tab to select it.
Effect tab appears, with our settings, as depicted in Illustration 24.
Illustration 24: 3-D
Effect Tab with Settings
checkbox to the immediate left of Display Chart with 3-D Visual Effect,
to place a checkmark there.
Click the General
tab to review settings.
tab appears, at this stage in our process, as shown in Illustration 25.
25: The General Tab with Settings
to accept all the settings we have made in the Chart Properties dialog
The Chart Properties dialog closes,
returning us to the generic chart item in Report Designer, Layout tab.