Change the look of graph text and labels in Numbers on Mac

You can change the look of all the graph text at once.

1. Click the graph, then in the Format  sidebar, click the Graph tab.

2. Use the controls in the Graph Font section of the sidebar to do any of the following:

   • Change the font: Click the Graph Font pop-up menu and select a font.

   • Change the character style: Click the pop-up menu below the font name and select 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 graph increases or decreases proportionally (by the same percentage).

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

Graphs have a place holder title (Title) that’s hidden by default. You can show the graph title and change it.

1. Click the graph.

2. In the Format  sidebar, click the Graph tab, then select the Title tick box.

3. Double-click the place holder title on the graph and type your own.

4. To change the look of the title — for example, its font, size and colour — double-click the title again, then use the controls in the Graph Title tab of the sidebar to make changes.

   To move the title to the centre of a doughnut chart, click the Title Position pop-up menu, then choose Centre.

Graphs have labels that show the values of specific data points. You can specify a format for them (for example, number, currency or percentage), change where they appear, how they look and more.

1. Click the chart, then in the Format  sidebar, do one of the following:

   • For pie or doughnut charts: Click the Wedges or Segments tab.

   • For other graph types: Click the Series tab.

2. To add value labels and choose the format for the value (for example, Number, Currency or Percentage), do one of the following:

   • For pie or doughnut charts: Select the Values tick box, then click the disclosure arrow next to the Value Data Format pop-up menu and choose an option.

     You can also display data labels in pie and doughnut charts by selecting the Data Point Names tick box.

   • For bubble charts: Click the disclosure arrow next to Bubble Labels, select the tick box next to Values, then click the Value Data Format pop-up menu and choose an option.

   • For scatter plots: Click the disclosure arrow next to Value Labels, select the tick box next to Values, then click the Value Data Format pop-up menu and choose an option.

   • For other types of graphs: Click the disclosure arrow next to Value Labels, then click the pop-up menu below and choose an option.

   If you want the value labels to match the format of the original data in the table, choose Same as Source Data.

   Tip: To add a value label to just one item in a graph — for example, one wedge in a pie chart — first select the item, then add the value label.

3. Fine-tune the value labels (these controls are available only for some graph types):

   • Set the number of decimal places: Click the up or down arrow.

   • Choose how to display negative numbers: Choose “−100” or “(100)”.

   • Show the thousands separator: Select the Thousands Separator tick box.

   • Add a prefix or suffix: Enter text. It’s added to the beginning or end of the label.

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

     When you create a graph, Auto-Fit is automatically turned on to prevent value labels from overlapping. To see all value labels, unselect the Auto-Fit tick box. (Not all graphs have an Auto-Fit tick box.)

4. To change the font, colour and style of the labels, click any value or data label on the graph, then use the controls in the Font section of the sidebar to make changes.

   To change the look of labels for just one data series, first select the series, then make changes. To select multiple series, click a value label, then Command-click a value label in another series. To select all series, click a value label, then press Command-A.

   Note: The font for all labels changes when you change the Graph Font in the Graph tab of the Format sidebar.

5. To position value and data labels in a pie or doughnut chart, and add leader lines to them, click the disclosure arrow next to Label Options, then do any of the following:

   • Change the position of the labels: Drag the Distance from Centre slider to set where the labels appear. Moving the labels further from the centre of the graph can help separate overlapping labels.

   • Add leader lines: Select the Leader Lines tick box. You can change the line type, colour and width of the leader lines and add endpoints to them.

   • Choose leader line form: Click the pop-up menu and select Straight or Angled. With angled leader lines, the call out aligns with columns, as shown below.

If you have a stacked column, stacked bar or stacked area graph, you can add a summary label to display the sum above each stack.

1. Click the stacked graph, then in the Format  sidebar, click the Series tab.

2. Click the pop-up menu under Summary Labels, then choose a number format for the label.

   Turn on Same as Source to use the same number format as the graph data.

3. To fine-tune how the summary label values are displayed, make your choices using the options that appear below the Summary Labels pop-up menu.

   The options vary depending on the chosen summary label format. For example, when Currency is selected, you can choose the number of decimals, whether negative values appear in parentheses or with a negative sign, and the currency format.

4. To add a prefix or suffix to each summary label, type the text you want to add in the fields below Prefix or Suffix.

5. To change the font, colour and style of the summary labels, click any summary label on the graph, then use the controls in the Font section of the Format sidebar to make changes.

   Note: The font for all labels changes when you change the Graph Font in the Graph tab of the Format sidebar.

6. To adjust the distance between the summary labels and the stacks, click the up or down arrows next to Offset.

You can specify which labels appear on an axis, edit their names, and change their angle of orientation.

1. Click the graph, then in the Format  sidebar, click the Axis tab.

2. Do either of the following:

   • Modify markings on the value axis: Click the Value (Y) button near the top of the sidebar.

   • Modify markings on the category axis: Click the Category (X) button near the top of the sidebar.

3. Use the controls in the sidebar to make any adjustments.

   To see all options, click the disclosure arrows to the left of the section headings.

   

4. If you selected the Axis Name tick box and want to change the name on the graph, click the graph, double-click the axis name on the graph, then type your own.

To change the font, colour and style of axis labels, click an axis label, then use the controls in the Font section of the sidebar to make changes.

You can edit the labels shown in a pivot chart. For example, you can show the group names from the pivot table on the x-axis. To learn how to create a pivot chart using a pivot table, see Select cells in a pivot table to create a pivot graph.

1. Select the pivot chart you want to edit.

2. In the Graph tab of the Format  sidebar, click the Pivot Data Labels pop-up menu, then choose the names you want to show, or choose Hide All Names.

   Note: The options you see in Pivot Data Labels may change based on the fields in the pivot table.