Create an interactive chart

An interactive chart presents data in stages so that you can emphasize the relationship between groups of data. You can use an interactive chart to show data like sales by group over time, expenses by department, and population changes by country per continent. The example below shows the growth of three species during a three-year period.

An interactive chart, which displays different data sets as you drag the slider

You can interact with the chart using a slider and buttons or buttons only.

Create an interactive chart

  1. Tap Add button, tap Chart button, then tap Interactive.

  2. Tap a chart to add it, then drag it to where you want it on the sheet.

  3. Tap to add data to the chart, then select the table cells with the data you want to use. Or, to add data from an entire row or column, tap the table, then tap the number or letter for that row or column.

    You can select cells in one or more tables, including tables on different sheets. While editing a chart’s data references, an icon appears on the tab for any sheet that contains data used in the chart.

  4. To change whether rows or columns are plotted as data series, tap Gear button for determining how chart data is plotted in the toolbar, then tap an option.

    The data series are always plotted in the interactive chart, but each data set is displayed separately.

  5. Tap Done in the toolbar.

Choose controls for interacting with the chart

In an interactive chart, you can switch between the different data sets using a slider and buttons or buttons only. You choose the controls for switching between data sets.

  1. Tap the chart, tap Format button.

  2. Tap Chart, then tap Chart Options.

  3. Tap Interactive Chart, then tap Slider and Buttons or Buttons Only.

See also
Modify chart data references
Adjust chart markings and labels