I have three data series (x-y) I want to plot as scatter graphs in Microsoft Excel.
I want the first series to be plotted using the bottom x-axis and left y-axis.
I want the second series to be plotted using the top x-axis and the left y-axis (again).
I want the third series to be plotted using the bottom x-axis and the right y-axis.
So I need four different axes on the four sides of the chart area. Excel seemingly can place primary and secondary horizontal and vertical axes okay but I can't seem to control which combination of these my data series are plotted to - only whether they are "primary" or "secondary" which isn't enough detail.
Any help would be greatly appreciated!