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 height of the columns in that series. Value
labels appear on the y-axis (we will examine format settings for these in our
subsection on the Y Axis tab below). Each Value series appears as
individual columns.
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.
18.
Click and drag
the arrow button on the Angle selector to its rightmost position on the
scale – until the number 90 appears within the read-only box to the
right of the arrow button.
This will
result in the point labels being displayed at 90-degree angles to
the tops of the columns of our chart, making the chart more compact and, in
this case, making the labels themselves somewhat easier to read.
19.
Click the Label
Style ... button immediately underneath the Angle setting.
The Style Properties dialog box appears.
20.
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
21.
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
22.
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
23.
Click the Data
Output tab of the Edit Chart Value dialog.
The Data
Output tab affords us a means of defining XML data output options
for the values in the chart. We will not leverage these capabilities within
this introduction to simple Column charts, and will therefore leave the
settings of the Data Output tab at their defaults, as shown in Illustration
25.
Illustration 25: The Data
Output Tab with Default Settings
» 
Comment and Contribute
