Modify chart data references

You can modify a chart’s data references in the chart data editor. You can enter only numbers, dates, or durations in data cells.

Add, delete, or edit a data series

  1. Select the chart, click Edit Chart Data, then do any of the following:

    • Add a data series: Click a cell in a new column or row, then enter your data.

    • Delete a data series: Click the colored bar for the row or column you want to delete, click the arrow that appears, then click Delete Column or Delete Row (depending on whether you plotted rows or columns as data series).

    • Reorder data series: Drag the colored bars to reorder the chart data series.

    • Add a currency symbol or other formatting: Click the Series tab at the top of the sidebar on the right, then use the controls in the Series tab.

    • Edit value labels and format numbers: Click the Series tab at the top of the sidebar on the right, click the disclosure triangle next to Value Labels, then select the Values checkbox. Click the pop-up menu to choose the axis you want to format, then use the controls in the Value Data Format section to make your settings.

  2. Close the Chart Data window to return to the chart.

Switch rows and columns as data series

When you add a chart, Keynote defines default data series for it. In most cases, if a table is square or if it’s wider than it is tall, the table rows are the default series. Otherwise, the columns are the default series. You can change whether rows or columns are the data series.

  1. Select the chart, then click Edit Chart Data.

  2. Click a row or column button in the top-right corner of the Chart Data editor.

    Plot rows and plot columns buttons
  3. Close the Chart Data editor when you’re done.

Share the x-axis for multiple values along the y-axis for scatter and bubble charts

Sharing the x-axis means plotting a single kind of value along the x-axis, while allowing for multiple kinds of values plotted along the y-axis. By default, the x-axis values are shared among multiple sets of y-axis values in some types of charts.

  1. Select the chart, then click Edit Chart Data.

  2. Click Configure button, then select (or deselect) Share X Values.

  3. Close the Chart Data editor when you’re done.