Tuesday, February 12, 2013

How to Add a Second Y


1.
Create an Excel graph for all the rows and columns. At the end of this step you will have a graph with some very high lines and the rest flat along the bottom.
2.
Select one of the lines which are causing the skewing of the graph. If more than one line is the culprit, select the highest.
3.
With the lines selected, right click on the graph and select 'Format Data Series.' This will open another box. In the new box, select 'Secondary Axis.' Then click the Close button.
4.
Your graph will now display the second Y-axis on the right of the graph and your lines will be spaced out.

Blogger news