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).
2.
Ensure that
the Show labels checkbox is checked.
3.
Click the
Style button to the immediate right of the blank Format code box.
The Style
Properties dialog box appears, once again.
4.
Make the
settings, listed in Table 2 below, within the Style Properties
dialog box:
|
Property
|
|
Setting
|
|
|
|
|
|
Family
|
|
Arial
|
|
Size
|
|
9pt
|
|
Style
|
|
Normal
|
|
Weight
|
|
Normal
|
|
Color
|
|
Black
|
|
Decoration
|
|
None
|
|
|
|
|
Table 2: Style Properties Dialog
The Style
Properties dialog appears, with our settings, as shown in Illustration 27.
Illustration 27: Style Properties Dialog Box with Settings
5.
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
28.
Illustration 28: 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
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.
2.
Type (or cut
and paste) the following into the Title box on the 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.
3.
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.
4.
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 29.
Illustration 29: Style Properties Dialog Box with Settings
5.
Click OK
to accept changes and to exit the Style Properties dialog box.
We return
to the Y Axis tab.
6.
Ensure that
the Show labels checkbox is checked.
7.
Type the
following into the Format code box:
#,###
8.
Click the
Style button to the immediate right of the newly occupied Format code
box.
The Style
Properties dialog box appears, once again.
9.
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 depicted in Illustration
30.
Illustration 30: Style Properties Dialog Box with Settings
10.
Click OK
to accept changes and to exit the Style Properties dialog box.
11.
Place a check in
the box labeled Major gridlines, just underneath the Format code
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 31.
Illustration 31: Chart Properties Dialog Box – Y Axis Tab, with Our Settings
We will
move to the Legend tab next.
» 
Comment and Contribute
