Hi,
Is it possible to get a graph with two Y-axes in Excel?
I have the following data:
X Y1 Y2
0.1 10,000 10
0.1 15,000 16
0.2 31,000 34
...
I would like to scatter plot both Y1 and Y2 on the same graph. But the problem is that numbers in Y1 are substantially higher than those in Y2.
Is there an Excel graph which would allow me to have two Y-axis, and which could draw the data into one graph so that all is properly visible.
I have seen such graphs in other applications, but was not able to find it in Excel. Do I need some special Excel AddIn or something?
Thanks for any comments
Bookmarks