iPad Office: How to Create a Chart in PowerPoint or Word

Use Excel for the heavy lifting

Screenshot of Excel

The Microsoft Office apps for the iPad have come a long way, but you still can't create charts in the Microsoft PowerPoint or Microsoft Word apps. The solution is to create the chart in the Excel app, copy it to the clipboard, and paste it into your Word or PowerPoint document.

Instructions in this article apply to Microsoft Excel, PowerPoint, and Word apps on iPads running iOS 12 or iOS 11.

Use Excel to Create a Chart for Powerpoint or Word

The Excel app is well-suited to handle simple or complex charts.

  1. Open a new spreadsheet in Excel or open an existing spreadsheet with data.

  2. If you are in a new spreadsheet, enter the data at the top of the page. Tap the Abc and 123 buttons to toggle the keyboard for data entry.

    Entering data into an Excel spreadsheet on iPad
  3. Select the data you want on the chart by tapping in one cell and using the handles to expand the selection.

    Selection of a range of data in Excel for iPad
  4. Tap Insert at the top of the screen, followed by Charts to display the different types of available charts.

    The Chart options in Excel for iPad
  5. Within each chart selection are several variations. Choose the desired chart format by tapping on it.

    Variations on a bar chart in Excel for iPad
  6. Examine the resulting chart. You don't need to worry about the size of the graph; You can adjust the size in PowerPoint or Word, but you do want to make sure everything else looks OK.

    A bar chart example in Excel for iPad

    When the chart is highlighted, the Chart Tools tab appears at the top. Use these tools to modify the graph by changing the layout, color scheme, or type of graph.

  7. When you're done making any adjustments, tap the chart to highlight it. A Cut/Copy/Delete menu appears above the chart. Tap Copy to copy the chart to the clipboard.

    Copying an Excel chart on iPad
  8. Launch Word or PowerPoint and open the document where you want to insert the chart.

    A new presentation file in PowerPoint for iPad
  9. Tap the area of the document where you want to insert the chart to open a menu that includes the Paste function.

    PowerPoint screen showing the Paste option
  10. Choose Paste to insert the chart.

    Pasting a chart from Excel into PowerPoint on iPad
  11. Drag the chart to move it to a new location in the document or use the circles (anchors) to resize the chart.

    PowerPoint slide showing resized chart from Excel on iPad