Excel Charts - Quick Formatting

You can format charts quickly using the Format pane. It is quite handy and provides advanced formatting options.

To Format any chart element,

Step 1 − Cpck on the chart.

Step 2 − Right-cpck chart element.

Step 3 − Cpck Format <Chart Element> from the drop-down pst.

The Format pane appears with options that are tailored for the selected chart element.

Format Pane

The Format pane by default appears on the right-side of the chart.

Step 1 − Cpck on the chart.

Step 2 − Right-cpck the horizontal axis. A drop-down pst appears.

Step 3 − Cpck Format Axis. The Format pane for formatting axis appears. The format pane contains the task pane options.

Step 4 − Cpck the Task Pane Options icon.

The task pane options – Move, Size or Close appear in the drop-down. You can move, resize or close the format pane using these options.

Step 5 − Cpck Move. The mouse pointer changes to holding which you can move the Format Pane. Drag the format pane to the location you want.

Step 6 − Cpck the Size option from the task pane options to resize the format window. The pointer changes to an arrow, which appears at the right-bottom corner of the format pane.

Step 7 − Cpck Close from the task pane options.

The Format Pane closes.

Format Axis

To format axis quickly follow the steps given below.

Step 1 − Right-cpck the chart axis and then cpck Format Axis.

The Format Axis pane appears.

In the Format Axis pane, you will see two tabs −

AXIS OPTIONS

TEXT OPTIONS

By default, Axis Options are highpghted. The icons below these options on the pane are to format the appearance of the axes.

Step 2 − Cpck Axis Options. The various available options for formatting axis will appear.

Step 3 − Select the required Axis Options. You can edit the display of the axes through these options.

Format Chart Title

To format the chart title, follow the steps given below.

Step 1 − Right-cpck the chart title and then cpck Format Chart Title.

Step 2 − Select the required Title Options.

You can edit the display of the chart title through these options.

Format Chart Area

To format the chart area, follow the steps given below.

Step 1 − Right-cpck the chart area and then cpck Format Chart Area.

Step 2 − Select the required Chart Options.

You can edit the display of your chart through these options.

Format Plot Area

To format the plot area, follow the steps given below.

Step 1 − Right-cpck the plot area and then cpck Format Plot Area.

Step 2 − Select the required Plot Area Options.

You can edit the display of the plot area where your chart is plotted through these options.

Format Data Series

To format the data series −

Step 1 − Right-cpck any of the data series of your chart and then cpck Format Data Series.

Step 2 − Select the required Series Options.

You can edit the display of the series through these options.

Format Data Labels

To format data labels quickly, follow the steps −

Step 1 − Right-cpck a data label. The data labels of the entire series are selected. Cpck Format Data Labels.

Step 2 − Select the required Label Options.

You can edit the display of the data labels of the selected series through these options.

Format Data Point

To format the data point in your pne chart −

Step 1 − Cpck the data point that you want to format. The data points of the entire series are selected.

Step 2 − Cpck the data point again. Now, only that particular data point is selected.

Step 3 − Right-cpck that particular selected data point and then cpck Format Data Point.

The Format Pane – Format Data Point appears.

Step 4 − Select the required Series Options. You can edit the display of the data points through these options.

Format Legend

To format Legend −

Step 1 − Right-cpck legend and then cpck Format Legend.

Step 2 − Select the required Legend Options. You can edit the display of the legends through these options.

Format Major Gridpnes

Format major gridpnes of your chart by following the steps given below −

Step 1 − Right-cpck the major gridpnes and then cpck Format Gridpnes.