Excel 2 Y Achsen. In the plot details dialog box click the link axes scales tab layer 2 and set x axis link to none and click ok. This wikihow teaches you how to add a second y axis to a graph in microsoft excel.
In this example we re charting collection dollars and the percent of billed charges on. But if your data has different units you may feel like you can t create the graph you need. Add or remove a secondary axis in a chart in office 2010.
Select your xyxy columns and choose plot multi panel axis.
Select your xyxy columns and choose plot multi panel axis. Learn to add a secondary axis to an excel chart. Select your xyxy columns and choose plot multi panel axis. In the plot details dialog box click the link axes scales tab layer 2 and set x axis link to none and click ok.