where is the scatter option in excel for mac

Where Is The Scatter Option In 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).

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

Where Is The Scatter Option In 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.

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

Double-click the placeholder title on the chart and type your own.

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, then 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 Value Data Format pop-up menu and choose an option.

For scatter charts: Click the disclosure triangle next to Value Labels, select the checkbox next to Values, then click the Value Data Format pop-up menu and choose an option.

For other types of charts: Click the disclosure triangle next to Value Labels, then click the Value Data Format pop-up menu and choose an option.

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.

Where Is The Scatter Option In Excel For Mac