iOS Excel—Plotting Multiple XY Series On Same Graph

Hi there. I am using Microsoft Excel on my iPad. I have two XY data pairs that I would like to plot on the same graph.


I have tried

Approach 1–Marking each column x1, y1, x2, y2 and placing the data in. Selecting all four groups of data with the column headers. Then I followed steps to graph the selected data as XY Scatter. This resulted in three series-y1, x2, y2 because x1 data was considered as the X column with three y data sets. Also, to illustrate that point, the graph legend showed the three series. This is not what I am trying to achieve.


Approach 2–Marking each column x1, y1, x2, y2 and placing the data in. Selecting all four groups of data without the column headers. Then I followed steps to graph the selected data as XY Scatter. This resulted in three series-Series 1, Series 2, Series 3 because x1 data was considered as the X column with three y data sets. Also, to illustrate that point, the graph legend showed the three series. This is not what I am trying to achieve.


Although iOS and MacOS Numbers both have the ability to Unshare X values, thus creating the two individual X/Y series plots on the same graph, how is this accomplished in the iOS version of Excel?


Thank you

iPad Pro 10.5-inch, Wi-Fi, Cellular, iOS 11.0.2

Posted on Oct 6, 2017 1:05 PM

Reply
3 replies

Oct 8, 2017 10:10 AM in response to Diana.McCall

Hello. Although the techniques seem to apply, since I am using Excel on an iPad with the Smart Keyboard, the Option, Control, or Shift modifiers don’t seem to affect the same selection functionality that would operate this illustrated way. Maybe I’m missing a step, but perhaps the iOS version of Excel does not have provisions to recognising these Option, Shift, Control selection methods.

Hopefully I am misunderstanding Excel for iOS and these selection and charting methods are possible. If these selection & charting methods are possible in Excel for iOS, I am still needing help.


Thank you.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

iOS Excel—Plotting Multiple XY Series On Same Graph

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.