the Data tab.
the 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 ...
the Add... button to the right of the Values list box, found immediately
underneath the Dataset name selector we populated above.
values in a Value series determine the length of the bars in that
series. Value labels appear on the x-axis (we will examine format
settings for these in our subsection on the X Axis tab below). Each Value
series appears as individual bars.
Chart Value dialog appears, defaulted to the Values tab.
the following into the Series label box, atop the Values
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 ...
the Fields (ProductData) option in the bottom left corner pane of
the Expression Editor.
values of the ProductData dataset appear within the pane to the bottom
right of the Expression Editor.
Internet_Sales_Amount 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 ...
8. 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...
the Appearance tab on the Edit Chart Value dialog.
the Series Style... button in the lower left corner of the Appearance
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.
11. Click OK
to dismiss the Style Properties dialog, and to return to the Appearance
tab of the Edit Chart Value dialog.
the Point Labels tab on the Edit Chart Value dialog.
the check box to the immediate left of Show point labels atop the Point
the downward pointing arrow to the right of the Data label box to
display data selection options.
15. Select =Fields!Internet_Sales_Amount.Value
from the options, as shown in Illustration 21.
Illustration 21: Select
=Fields!Internet_Sales_Amount.Value as the Data Label ...
the Format code box (just underneath the Data label selector)
type the following character pattern:
the Auto checkbox to the right of the Format code box.
result in the point labels being displayed horizontally at the edges of
the bars of our chart, making the chart more compact and, in this case, making
the labels themselves somewhat easier to read.
the Label Style ... button immediately underneath the Angle
The Style Properties dialog box appears.
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
Illustration 22: Style
Properties Dialog Box with Settings
20. Click OK
to accept settings.
Properties box closes. We return to the Edit Chart Value dialog
box, which now appears as shown in Illustration 23.
Illustration 23: The
Edit Chart Value Dialog Box, with Our Input
the Action tab of the Edit Chart Value dialog.
can define Hyperlink actions, including Jump to report, Jump
to bookmark, or Jump to URL. We will not be working with a
drillthrough scenario in this practice session, and so will leave undisturbed
the default setting of None, as depicted in Illustration 24.
Illustration 24: The
Action Tab of the Edit Chart Value Dialog Box
the Data Output tab of the Edit Chart Value dialog.