Computers, Laptops & Tablets Apple How to Create a Graph in Excel for iPad Turn plain data into a colorful visualization Share Pin Email Print Hero Images/Getty Images Apple iPad Macs By Daniel Nations Writer Daniel Nations has been a tech journalist since 1994. His work has appeared in Computer Currents, The Examiner, The Spruce, and other publications. our editorial process Facebook Twitter LinkedIn Daniel Nations Updated July 19, 2019 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: Open the spreadsheet that contains the data you want to convert into a chart. Tap the upper-left cell of the data. 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. Go to the Insert tab and choose Charts. 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. 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. 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.