How to Create a Graph in Excel for iPad

Male using digital tablet in the office.
Hero Images/Getty Images

On your iPad, you can quickly transform your Excel spreadsheet from a boring heap of numbers into an attractive chart. While Microsoft strangely left charts out of the release of Word and PowerPoint for iPad, it's rather easy to create them in Excel, and then paste them into Word or PowerPoint as needed.

These instructions apply to Excel for iPad 2.25, which is compatible with devices running iOS 11 or later.

Creating a Basic Chart in Excel for iPad

  1. Open the spreadsheet that contains the data you want to convert into a chart.

  2. Tap the top-left cell of your data grid.

    Making a chart in Excel for iPad
  3. Drag the anchor (the dot in the lower-right corner of the cell) to select all the cells you want to use.

    To select the entire sheet, tap the triangle in the upper-left corner.

    Making a chart in Excel for iPad
  4. Tap Insert at the top of the screen and choose Charts.

    Making a chart in Excel for iPad
  5. Tap the type of chart you want Excel to create.

    You can also tap Recommended. Excel will recommend types of charts with previews.

    Creating a chart in Excel for iPad
  6. Excel will generate a chart based on the data and format you selected.

Editing Your New Excel Chart

You can make adjustments to the new chart. Here are a few of the changes you can make to get it looking perfect. Tap the chart to select it and show the Chart options at the top of the screen.

Editing a chart in Excel for iPad

Some features are only available with a paid Office 365 subscription.

  • Tap Types to change the kind of chart. Use this if you made a pie chart and want to change it to a line chart, for example.
  • Layouts shows you different options for the type of chart you've already made. Use this to keep the type the same but put labels, etc. in different places.
  • Elements lets you move elements like the title and legend to different places.
  • Colors changes the look of your chart with different pallets.
  • Styles lets you switch between different typefaces, background patterns, and gradients for your chart.
  • Switch swaps the x and y-axes on the chart.