Hi, I need to utilise this information from my data in excel, without this functionality I cannot do the work that I need and it makes using excel on iOS useless. Excel on my iPad is great, and I would be able to use it fully however this is very limiting. I need to use the desktop version for this functionality.

I'm not able to select non-adjacent cells in Excel on the iPad Pro. That means that I can;t selectively apply formulas or build charts with data from non-adjacent columns. It's an absurd thing not to be able to do. Under any other circumstances this would be a matter fo just hitting the Ctrl button. You all need to fix this immediately, I feel like I've been sold something non-functional.

On a PC, I can make an XY scatterplot, and get a trendline, and get the equation and R squared value. But on an ipad, I cannot get the equation of the line. I have a lab exercise with my college students that requires them to make a scatterplot, and then use the equation of the line to predict Y values given an X value, or vice versa. Our college just purchased new ipads for all students, so I was very disappointed they cannot use their new ipads for this exercise.

I have to use scatter plots for many labs for college and that means that there are multiple test per experiment resulting in multiple tables per experiment. These multiple tables need to be added into a single scatter plot as different series.

You can create charts in Excel, and use sliders to include more series, but it only works if all data points are inside a table.

If data series are in different parts of a sheet, Excel for iOS cannot edit the source data to pick the right data.

Please add this feature.

Need ability to manually edit or specify data ranges for scatter plots. Currently is automatically determined from initial range selection during chart creation, and this is frequently incorrect.

That I know of, there's no way to create a graph and then edit the data series afterwards. Clearly there are multiple data series created in some charts but I don't see a way to view / edit them without a lot of tedious dragging control handles around in the spreadsheet. It would be so much better to be able to have a dialog box pop up and hand edit the data series.

Currently the only way to see the equation and r-squared value for a linear trendline is to use a quick layout. If you do that, you can not hide either the equation or the R-squared, and more importantly, you can not move it around on the chart so that it doesn't overlap other elements. Also, I'd prefer to see enabling the equation and R-squared as part of the Elements option as opposed to that being kind of hidden under layouts.

Scatter plots for Scientific data measured by students often fit a parabola shaped trendline, i.e. a polynomial trendline with an order of 2. If supporting a polynomial trendline like desktop Excel is too computationally intensive, how about at least supporting a quadratic trendline (i.e. polynomial or order 2) inlcuidng the ability to show the equation and r-squared value. This would allow students to use iPad Excel to make predictions from data analysis done with the iPad.

Charts currently only allow selection of colour groups which rarely match the message I need to convey. I need to be able to select the display colour of individual data series in charts (bars, sectors or lines) and sometimes even individual parts of data series.

It would be nice if there is an easier way to add column and row headers to a chart. Currently there is no choice, unless you organize your data such that the intended headers are immediately adjacent to the data