Microsoft Office Tutorials and References
In Depth Information
Miscellaneous Adjustments
To complete the chart we have one
necessary adjustment to make, and one
optional adjustment.
10
8
6
4
2
0
Jan
04
Apr Jul Oct Jan
05
The necessary adjustment is to remove the
chart’s title. It takes up too much space in the
chart and reduces flexibility in your
spreadsheet.
10
8
6
4
To remove the title, click on the Chart Title
object in the chart, and then press the Delete
key.Then reduce the size of the chart object
to recover the space that the title had used.
0
Jan
04
Apr Jul Oct Jan
05
The chart does need a title, of course. I’ll explain how to replace the
title later in Chapter 8, using a more flexible approach.
The optional adjustment is to add gridlines, as shown in the second
figure. First select the chart object and then choose Chart, Chart
Options. In the Gridlines tab, select the Major gridlines check box in
the Category (X) Axis section.
Second, modify the gridlines so that they display every quarter, not
every month. To do so, first select the X axis. Choose Format,
Selected Axis. In the Scale tab, enter 3 in the text box labeled
“Number of categories between tick marks.”
These figures show the final results for this stage of development.
We have charts that are missing key information, but which display
our data in a space that’s not much larger than a postage stamp.
Of course, you might object that you don’t want your charts this
small. But with these techniques available, you have the flexibility to
make your charts as large or as small as you want. You no longer
face limits that appeared to be imposed by Excel’s chart object.
 
Search JabSto ::




Custom Search