Select data to make a chart in Numbers on iPhone

In Numbers, charts are created using data from a table. To create any type of chart, you can select the data first, then create a chart that displays the data. When you change the data in the table, the chart updates automatically.

Select the data before creating your chart

  1. Go to the Numbers app on your iPhone.

  2. Open a spreadsheet, then select the table cells with the data you want to use. If you want to add data from an entire row or column, tap the table, then tap the number or letter for that row or column.

    If the data in your table is categorized, you can also select a column to plot the results of summary row calculations.

    Note: To chart individual data points in a categorized table, make sure the first cell you select is not in a summary row. If the selection includes a group that’s collapsed, only data from the visible groups is plotted.

  3. Tap the Cell Action menu button at the bottom of the screen, then tap Create New Chart.

  4. Tap 2D, 3D, or Interactive.

    Swipe to see more style options for each type of chart.

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

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

  6. To change whether rows or columns are plotted as a data series, tap the chart, tap the Forward button, tap Edit References, tap the Configure button in the toolbar, tap an option, then tap the Done button.

Select cells in a pivot table to create a pivot chart

When you create a pivot chart, you can plot different data (such as Grand Totals) based on the cells you select. The pivot chart below displays the values in the Total rows (Electric and Manual) in the pivot table.

A pivot table showing summarized data and controls to disclose certain data.
A pivot chart showing plotted data from the Total rows in the pivot table above.
  1. Go to the Numbers app on your iPhone.

  2. Open a spreadsheet with a pivot table, then select a cell (such as a Total or Grand Total cell) that includes the values you want to plot.

  3. Tap the Cell Action menu button at the bottom of the screen, then tap Create New Chart.

  4. Tap 2D, 3D, or Interactive, then tap a chart.

    Swipe to see more style options for each type of chart.

You can adjust the data reflected in the chart at any time. To learn how, see Modify chart data.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.