, ,

65. Formatting Charts


Want create site? Find Free WordPress Themes and plugins.

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 − Click on the chart.

Step 2 − Right-click chart element.

Step 3 − Click Format <Chart Element> from the drop-down list.

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 − Click on the chart.

Step 2 − Right-click the horizontal axis. A drop-down list appears.

Format Pane

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

Format Axis

Step 4 − Click the Down Arrow 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.

Task Pane Options

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

Drag Format Pane

Step 6 − Click 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.

Format pane Resized

Step 7 − Click Close from the task pane options.

The Format Pane closes.

Format Axis

To format axis quickly follow the steps given below.

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

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 highlighted. The icons below these options on the pane are to format the appearance of the axes.

Axis Options

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

Available Axis Options

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-click the chart title and then click Format Chart Title.

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-click the chart area and then click Format Chart Area.

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-click the plot area and then click Format Plot Area.

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-click any of the data series of your chart and then click Format Data Series.

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-click a data label. The data labels of the entire series are selected. Click Format Data Labels.

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 line chart −

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

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

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

The Format Pane – Format Data Point appears.

Format Data Point

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-click legend and then click Format Legend.

Format Legend

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

Format Major Gridlines

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

Step 1 − Right-click the major gridlines and then click Format Gridlines.

Did you find apk for android? You can find new Free Android Games and apps.
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.