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

You can use Excel spreadsheets to convert a collection of numbers into an attractive, easy-to-understand chart. While Microsoft left charts out of the iOS versions of Word and PowerPoint, it is possible to copy and paste Excel charts into those programs 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 would like to convert into a chart.

  2. Select the top-left cell in the spreadsheet.

    Making a chart in Excel for iPad
  3. Drag the dot in the lower-right corner of the cell (also known as the "anchor") to select all the cells containing the data you'd like to include.

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

    Making a chart in Excel for iPad
  4. Under the Insert tab, select Charts.

    Making a chart in Excel for iPad
  5. Select the type of chart you want Excel to create. Excel will then generate a chart based on the data and format you've selected.

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

Creating a chart in Excel for iPad

How to 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. Select the chart to reveal 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.

  • Select Types to change the kind of chart. Use this if you made a pie chart, for example, and want to change it to a line chart.
  • Select 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.
  • Select Elements to move elements such as the title and legend to a different location.
  • Select Colors to change the look of the chart with different color pallets.
  • Select Styles to switch between different typefaces, background patterns, and gradients for the chart.
  • Select Switch to swap the x and y-axes on the chart.