Label Chart Axis Excel How To Style The

To select multiple series, click a value label, then Command-click a value label in another series.

Change the font, style, and size of chart text You can change the look of all the chart text at once.

Click the chart, then in the Format sidebar, click the Chart tab.

Use the controls in the Chart Font section of the sidebar to do any of the following: Change the font: Click the Chart Font pop-up menu and choose a font.

Change the character style: Click the pop-up menu below the font name and choose an option (Regular, Bold, and so on).

Make the font smaller or larger: Click the small A or the large A.

All text in the chart increases or decreases proportionally (by the same percentage).

Label Chart Axis Excel How To Style The

To learn how to style the chart title and value labels so they look different from the other text, see the topics below.

Edit the chart title Charts have a placeholder title ( Title ) thats hidden by default.

In the Format sidebar, click the Chart tab, then select the Title checkbox.

To change the look of the titlefor example, its font, size, and colordouble-click the title again, then use the controls in the Chart Title tab of the sidebar to make changes.

To move the title to the center of a donut chart, click the Title Position pop-up menu, then choose Center.

Add and modify chart value labels Charts have labels that show the values of specific data points.

You can choose a format for them (for example, number, currency, or percentage), change where they appear, and more.

Click the chart. In the Format sidebar, click the Series tab.

Do any of the following: For bubble charts: Click the disclosure triangle next to Bubble Labels, select the checkbox next to Values, then click the pop-up menu and choose a value format.

For scatter charts: Click the disclosure triangle next to Value Labels, select the checkbox next to Values, then click the pop-up menu and choose a value format.

For other types of charts: Click the disclosure triangle next to Value Labels, then click the pop-up menu and choose a value format.

To hide the value labels, deselect the Values checkbox or choose None from the pop-up menu.

Fine-tune the value labels (these controls are available only for some chart types): Set the number of decimal places: Click the up or down arrow.

Show the thousands separator: Select the Thousands Separator checkbox.

Specify where labels appear: Click the Location pop-up menu and choose an option, such as Top, Middle, Above, or Inside (the options depend on your chart type).

To change the font, color, and style of the labels, click any value label on the chart, then use the controls in the Font section of the sidebar to make changes.

To change labels for another series, click one of its labels, then make changes.

Label Chart Axis Excel For Mac