Computers, Laptops & Tablets Apple How to Create a Graph in Excel for iPad Turn plain data into a colorful visualization 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 February 28, 2020 Hero Images / Getty Images Apple iPad Macs Tweet Share Email 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: Open the spreadsheet that contains the data you would like to convert into a chart. Select the top-left cell in the spreadsheet. 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. Under the Insert tab, select Charts. 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. 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. 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.