X Axis Tab
- Click
the X Axis tab.
We advise
our client colleagues that the labels assigned to the groups that we created
earlier will suffice to address the visual x-axis, and that we therefore need
only to deal with the labels settings (we can leave the Title and other
settings at default).
- Ensure
that the Show labels checkbox is checked.
- Click
the Style button to the immediate right of the blank Format code box.
The Style
Properties dialog box appears, once again.
- Make
the settings, listed in Table 3 below, within the Style Properties dialog
box:
Property
|
|
Setting
|
|
|
|
Family
|
|
Arial
|
Size
|
|
9pt
|
Style
|
|
Normal
|
Weight
|
|
Normal
|
Color
|
|
Black
|
Decoration
|
|
None
|
|
|
|
Table 3: Style Properties Dialog
The Style
Properties dialog appears, with our settings, as shown in Illustration 33.
Illustration 33: Style Properties Dialog Box with Settings
- Click OK
to accept changes and to exit the Style Properties dialog box.
We return
to the X Axis tab, once again, where we will leave all else at default. The X
Axis tab appears, with our settings, as depicted in Illustration 34.
Illustration 34: Chart Properties Dialog Box X Axis Tab with Our Settings
We will
move to the Y Axis tab in the next subsection.
Y Axis Tab
- Click
the Y Axis tab.
We
propose doing a little more adjustment to the default settings in the Y Axis
tab than we witnessed in its X Axis counterpart in the section above. These
modifications will be primarily in the interest of presentation compactness and
clarity. They will also demonstrate, in a small way, the power we can leverage
through the use of expressions in various value definitions within Reporting
Services.
- Type (
or cut and paste) the following into the Title box on the General tab:
="Total Internet "& vbcrlf &" Sales" &""
Here we
are adding the title Total Internet Sales, using the vbcrlf keyword within
the expression to force the word Sales into a second row of the title, so
that the title takes up less vertical space.
- Click
the Style button to the immediate right of the Title box.
The Style
Properties dialog box appears, as we have seen in earlier sections.
- Make
the settings, listed in Table 4 below, within the Style Properties dialog
box:
Property
|
|
Setting
|
|
|
|
Family
|
|
Arial
|
Size
|
|
9pt
|
Style
|
|
Normal
|
Weight
|
|
Normal
|
Color
|
|
Black
|
Decoration
|
|
None
|
|
|
|
Table 4: Style Properties Dialog
The Style
Properties dialog appears, with our settings, as shown in Illustration 35.
Illustration 35: Style Properties Dialog Box with Settings
- Click OK
to accept changes and to exit the Style Properties dialog box.
We return
to the Y Axis tab.
- Ensure
that the Show labels checkbox is checked.
- Type
the following into the Format code box:
#,###
- Click
the Style button to the immediate right of the Format code box.
The Style
Properties dialog box appears, once again.
- Make
the settings, listed in Table 5 below, within the Style Properties dialog
box:
Property
|
|
Setting
|
|
|
|
Family
|
|
Arial
|
Size
|
|
9pt
|
Style
|
|
Normal
|
Weight
|
|
Normal
|
Color
|
|
Black
|
Decoration
|
|
None
|
|
|
|
Table 5: Style Properties Dialog
The Style
Properties dialog appears, with our settings, as depicted in Illustration 36.
Illustration 36: Style Properties Dialog Box with Settings
- Click OK
to accept changes and to exit the Style Properties dialog box.
We return
to the Y Axis tab, once again, where we will leave all else at default. The Y Axis tab appears, with our settings, as
shown in Illustration 37.
Illustration 37: Y Axis Properties Dialog Box General Tab with Our Settings
We will
move to the Legend tab next.