Add or delete a chart

You can display your data using 2D, 3D, and interactive charts.

After you create a chart, enter data for the chart in the chart data editor. When you make changes in the chart data editor, the chart updates automatically.

Create a column, bar, line, area, or pie chart

  1. Click Chart button in the toolbar, then click 2D, 3D, or Interactive.

  2. Select a type of chart.

    Click the left and right arrows to see more color and style options.

    If you add a 3D chart, you see Rotation control at its center. Drag this control at any time to adjust the chart’s orientation.

  3. Click Edit Chart Data.

    The Chart Data Editor appears with placeholder data.

  4. Enter your own data in the Chart Data editor.

    You can add numbers, dates, or durations in the data cells. To format the numbers, click the Value Labels pop-up menu in the Series tab of the sidebar on the right.

  5. To change whether rows or columns are plotted as data series, click one of the buttons at the top-right corner of the table.

Create a scatter chart

Scatter charts show relationships between two or more sets of data. They display data as points and require at least two columns or rows of data (x and y values) to plot values for a single data series. By default, each data series in a scatter chart shares the x-axis value, so you need to add only an additional row or column to show another data series.

  1. Click Chart button in the toolbar, click 2D or Interactive, then click the scatter chart.

    For more scatter chart styles, tap Interactive. Click the right and left arrows to see more color and style options.

  2. Click Edit Chart Data.

    The Chart Data Editor appears with placeholder data. Each colored column represents a data series to be plotted on the chart.

  3. Enter your own data in the Chart Data Editor.

    To format the data as numbers, dates, or durations, 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 Value Labels pop-up menu and choose an option. For more information about formatting value labels, see Modify chart data references.

  4. Do any of the following:

    • Change whether rows or columns are plotted as data series: Click a button in the top-right corner of the Chart Data Editor.

    • Use a different x-axis value for each data series: Click Configure button, then deselect Share X Values. Click each cell to enter your own x and y values for the data series.

    • Add another data series: Type a new data series name in the next empty column (or row, if plotting by rows), then press Return.

  5. Close the Chart Data Editor to return to your chart.

Create a bubble chart

You can use a bubble chart to plot data with three dimensions. Each data series includes a third dimension that conveys the relationship between the compared values (x and y) and a size value (z). The size value determines the size of the bubble.

By default, each data series in a bubble chart shares the x-axis value, so you need to add only two additional rows or columns of data to show another data series. If you choose to use independent x-axis values, you need to add three additional rows or columns (x, y, and z) to show another data series.

  1. Click Chart button in the toolbar, click 2D or Interactive, then click the bubble chart.

    For more bubble chart styles, tap Interactive. Click the left and right arrows to see more color and style options.

  2. Click Edit Chart Data.

    The Chart Data Editor appears with placeholder data (x-axis, y-axis, and size values). Each colored column represents a data series to be plotted on the chart.

  3. Click each cell to enter your own x, y, and size values for the data series.

    To add another data series, type a new data series name in the next empty column (or row, if plotting by rows), then press Return.

  4. To change whether rows or columns are plotted as a data series, click a button at the top-right corner of the Chart Data Editor.

  5. If you don’t want to use the same x-axis values for each data series, click Configure button, then deselect Share X Values.

  6. Click the Series tab at the top of the sidebar on the right.

    If you don’t see the sidebar, or it doesn’t have a Series tab, click Format button in the toolbar.

  7. In the Bubble Data section of the sidebar, click the size values pop-up menu, then choose how you want to represent bubble size values (area or diameter).

  8. If you want to show bubbles with a negative value, select the “Show negative bubbles” checkbox.

Delete a chart

  • Select the chart, then press Delete.