Edit source data for charts

Question

Is it possible to edit the source data for charts in Excel for iPad and add category labels?

In Excel for Windows you can select data cells in a sheet to create a chart, and add category labels later. For example, if I have fiscal data for country X and Y from 1990 to 2014. In Windows I can select the data and create a chart, then manually label the first series as X, the second series as Y, and add 1990 to 2014 as the time dimension. 

In Excel for iPad, after I select the data and create a chart, I cannot create these labels.

Answer 1

Hi Ralph!

Thanks for using Excel for the iPad. And thanks for your question.

In Excel for iPad you can edit the source data for your chart by directly editing the values in the cells in the spreadsheet just like on desktop versions of Excel. You can also change the source data range (e.g. adding a new series) by manipulating the colored highlight borders that appear in the spreadsheet when a chart is selected. But you cannot make changes to the category labels or the series names directly in the chart.

However, you should be able to get the chart you want by forming your source data with series names and category labels, then using the Recommended chart command on the Insert tab.

Let me know if this doesn't quite answer your question.

Answer 2

This option is not available in Office for iPad.

Answer 3

This doesn't seem to work if the data and charts are on separate sheets

Answer 4

Thanks, but what I would like to see is the ability to select row and column headers that are not adjacent to the data. In my case, the data is often in the middle of a worksheet, while the headers (years and variable names) are row 1 and column A.

Answer 5

June 2016, latest iPad version of Excel on iPad Air 2: does not highlight source cells as descrbied so cannot make any changes. Source on same sheet as chart.