Microsoft Office Tutorials and References
In Depth Information
STEP 2: FORMAT THE CHART
STEP 2: FORMAT THE CHART
The next step is to provide some formatting and customizations. I start with the chart
title, which will be displayed in the bottom right corner of the chart (the legend will
effectively serve as the title).
1. Double-click the chart’s title to display the Format Chart Title dialog box.
2. Choose the Font tab and turn off the Auto scale option. Set the font to
10-point Arial, Italic.
3. Drag the title to the lower-right corner of the chart.
Notice that the font Auto scale option is turned off for all items in this chart.
This ensures that charts created in this format will all use the same font size,
regardless of the size of the chart.
Next, format the legend.
1. Double-click the chart’s legend to display the Format Legend dialog box.
2. Choose the Patterns tab and set the Border to None and the Area to None.
3. Select the Font tab and turn off the Auto scale option. Set the font to
14-point Arial, Bold.
4. Select the Placement tab and choose the Top option.
The following steps make some adjustments to the Plot Area.
1. Select the Plot Area and resize it so that it fills the gap left by the legend.
You may also need to adjust the height so that the chart title (in the
bottom right corner) does not interfere with the axis labels.
2. Double-click the chart’s plot area to display the Format Plot Area
dialog box.
3. In the Patterns tab, set the color to light yellow.
At this point, the chart should resemble Figure 2-29.
More formatting is required. Let’s do the axes next.
1. Double-click the horizontal value axis to display the Format Axis
dialog box.
2. Select the Scale tab and set the Maximum to 0.6. Doing so overrides
automatic scaling and ensures that all charts created from the custom chart
type use the same scale.
Search JabSto ::




Custom Search