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