Help with a logarithmic x-axis problem

[dairek]

Hi, I've been struggling with a graph I'm doing for a lab report, and I've been unable to find a solution online.

I have two series, each with separate y-axes (linear) and both plotted on a logarithmic x-axis with the same x-axis values for both series. I expected the points on both series to line up vertically (since they have the same x-axis values) but as soon as I select a secondary y-axis for my second series, the second series markers cluster to the left as though they are no longer plotted on a logarithmic x-axis, and the two series no longer line up vertically.

I've tried making this graph in various orders, selecting both series together and separately, but I can't get this to work out.

Help me please!!

dairek

 

[AhoyNC]

Dairek
I've run into this same problem when adding a secondary y axis Excel seems to get confused on values for x axis.

If you are using 2007 0r 2010 click on the graph.
Right click and "Select Data"
Look to make sure both series show the same values for the horizontal (x) axis. If not you can edit it from here.
Hope this helps. Good Luck.

 

[dairek]

Hey AhoyNC,

I've tried that - they are set for the same x-axis values so I just can't understand how the points won't like up I've resorted to using two separate graphs to display these data.

Thanks for the suggestion though!

- dairek