Adjust a chart’s markings and labels

There are several types of chart markings and axis labels you can add to your charts. You can modify their appearance to emphasize your data.

Chart with axis value labels, grid lines, category labels, and legend

To edit a chart, make sure it’s unlocked.

Edit the chart title

Charts have a placeholder title (Title) that’s hidden by default. You can show the chart title and change it.

  1. Tap the chart, tap Format button, then tap Chart Options.

  2. Tap Chart Title, then turn on Chart Title.

  3. To change the alignment of the title—so it’s on the left of the chart, for example—tap an alignment option.

  4. To edit the title, triple-tap the title, type a new one, then tap Done.

Add and modify chart value labels

Charts have labels that show the values of specific data points. By default, these value labels are hidden for new charts, but you can make them visible and specify a format (for example, number, currency, or percentage) for them, change their font and color, and more.

  1. Tap the chart, tap Format button, then tap Chart.

  2. Tap Chart Options, tap Value Labels, then tap a location for the labels (for example, Top or Middle), which refers to where they appear on the data series in the chart.

  3. To modify the number format for the labels, tap Chart Options again, tap Number Format (below Values), turn off Same as Source, then choose a format.

    If Same as Source is turned on, the value labels match the format of the original data in the table.

  4. Use the other controls to make further adjustments to the labels:

    • Add a suffix or prefix: The text you enter is appended or prepended to the value label.

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

If you change the font for the entire chart, it also changes the font for the value labels.

Add and modify bubble chart value labels

  1. Tap the chart, tap Format button, then tap Chart.

  2. Tap Chart Options, tap Bubble Options, then turn on Series Names.

  3. To show value labels, tap Values, then tap an option.

  4. To change the location of the label, tap Label Location, then tap an option.

    If your chart has overlapping bubbles, turn off Show Labels In Front (scroll to the bottom to see it) to show only the label for the topmost bubble.

  5. To modify the number format for the labels, tap Chart Options again, tap Number Format (below Values), turn off Same as Source, then choose a format.

    If Same as Source is turned on, the value labels match the format of the original data in the table.

  6. Use the other controls to make further adjustments to the labels:

    • Add a suffix or prefix: The text you enter is added to the beginning or end of the value label.

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

Modify chart axis labels and grid lines

Most types of charts have axis markings, which you can modify in a number of ways. You can change which labels appear on an axis, the angle of the labels, the range and frequency of the markings, and more. You can also set whether to show chart grid lines, and specify their appearance.

  1. Tap the chart.

  2. Tap Format button, then tap X-Axis or Y-Axis.

  3. Use the controls to make any adjustments you want.

If you turn on Axis Name, Numbers adds a placeholder axis name to the chart. To change it, double-tap the name on the chart, then type your own.

Add a chart legend

  1. Tap the chart, tap Format button, then tap Chart.

  2. Tap Chart Options, then turn on Legend.

  3. To adjust the size of the legend, tap the legend, then drag the green selection handles.

  4. Drag the legend to where you want it.

See also
Modify chart data references
Change the look of a chart