Data Tab
1. Click
the Data tab.
2. Using
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 ...
3. 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 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.
The Edit
Chart Value dialog appears, defaulted to the Values tab.
4. Type
the following into the Series label box, atop the Values
tab:
Internet Sales
5. 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 ...
The Expression
Editor opens.
6. Click
the Fields (ProductData) option in the bottom left corner pane of
the Expression Editor.
The field
values of the ProductData dataset appear within the pane to the bottom
right of the Expression Editor.
7. Double-click
Internet_Sales_Amount to place this selection into the main pane
atop the Expression Editor.
The Expression
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.
We are
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...
9. Click
the Appearance tab on the Edit Chart Value dialog.
10. Click
the Series Style... button in the lower left corner of the Appearance
tab.
The dual
– 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.
12. Click
the Point Labels tab on the Edit Chart Value dialog.
13. Click
the check box to the immediate left of Show point labels atop the Point
Labels tab.
14. Click
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 ...
16. Within
the Format code box (just underneath the Data label selector)
type the following character pattern:
#,###
17. Uncheck
the Auto checkbox to the right of the Format code box.
This will
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.
18. Click
the Label Style ... button immediately underneath the Angle
setting.
The Style Properties dialog box appears.
19. Make
the settings, listed in Table 2 below, within the Style
Properties dialog box:
|
Property
|
|
Setting
|
|
|
|
|
|
Family
|
|
Arial
|
|
Size
|
|
7pt
|
|
Style
|
|
Normal
|
|
Weight
|
|
Normal
|
|
Color
|
|
Red
|
|
Decoration
|
|
None
|
|
|
|
|
Table 2: Style Properties Dialog
The Style
Properties dialog appears, with our settings, as depicted in Illustration
22.
Illustration 22: Style
Properties Dialog Box with Settings
20. Click OK
to accept settings.
The Style
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
21. Click
the Action tab of the Edit Chart Value dialog.
Here we
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
22. Click
the Data Output tab of the Edit Chart Value dialog.
» 
Comment and Contribute
