Format a Chart
There are many elements to a chart such as its legend, axis, data series and so on. Each element can be formatted in a number of ways from changing the colour of the columns to changing the scale of the value axis.
- Click on the chart element you want to format to select it, or select it by clicking the Chart Objects drop list on the Standard toolbar
- Double click the chart element or click the Format button on the Standard toolbar to open the required Format dialogue box
- Select the options you want and click Ok
The Chart Objects drop list shows all the chart elements that can be formatted
The Format dialogue box has a number of tabs providing many formatting options available for that chart element. Some chart elements have more formatting options than others. The image below shows the Format Axis dialogue box.