How to Create a Graph in Excel for iPad

Turn plain data into a colorful visualization

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

On the iPad, you can quickly transform an Excel spreadsheet from a collection of numbers into an attractive chart. While Microsoft left charts out of Word and PowerPoint for iPad, it's easy to create them in Excel and paste the charts 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.

Create a Basic Chart in Excel for iPad

To convert numbers in a spreadsheet to a chart:

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

  2. Tap the upper-left cell of the data.

    Making a chart in Excel for iPad
  3. Drag the anchor (the dot in the lower-right corner of the cell) to select the cells that contain the data for the chart.

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

    Making a chart in Excel for iPad
  4. Go to the Insert tab and choose Charts.

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

    If you're not sure how your data would be best represented, tap Recommended. Excel will recommend types of charts with previews.

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

Edit 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 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.
  • Tap Layouts to choose different options for the type of chart you made. Use this to keep the type the same but put labels in different places.
  • Tap Elements to move elements such as the title and legend to a different place.
  • Tap Colors to change the look of the chart with different color pallets.
  • Tap Styles to switch between different typefaces, background patterns, and gradients for the chart.
  • Tap Switch to swap the x and y-axes on the chart.