I found a workaround for this problem, after trying to apply the suggestion from dav (but being unable to find that setting in Office for Mac 2011). I converted the graph type to Area, then made the line thick and the fill transparent. How to add the drop through customization on page sown with value. Auxiliary axis Y on chart. How to add a 2nd hard drive for HP Pavilion DV7! XYGraph secondary axis. How to add friends again Apple Watch. How to add new folders in thunderbird for mac 38.2.0 POP3.
Create the scatter plot with your x-values and first set of y-values. Select the second group of y-values in your table, and drag the selection to the chart. Drag the same selection to the chart a second time, and some new data points will appear (don't worry if they're not in the right location at this point).
Click on one of the data points from the second group. Now go to the Chart Inspector, choose the 'Series' tab and edit the X-Data entry to reflect the same x-values range as for your first series of data.
Click on one of the data points from the second group. Now go to the Chart Inspector, choose the 'Series' tab and edit the X-Data entry to reflect the same x-values range as for your first series of data.
![Add a secondary axis to an excel chart Add a secondary axis to an excel chart](/uploads/1/2/6/2/126267456/472735465.jpg)
May 24, 2009 6:44 PM