I have an odd problem which seems like a bug, but it may be a "feature." Does anyone know how to handle this? My version is Excel 2007.
I have data with common values for the independant variable (X axis, horizontal axis) but of different orders of magnitude for the dependant variables (Y axis, virtical axis.) So I'm using the secondary axis, which works just like it's supposed to, since this is exactly the situation for which it exists. The graph is made with the "X Y (Scatter)" type, since my independant variable values are not evenly spaced.
But, the nature of the data is such that I want the horizontal axis to be logorithmic. So, I format the axis with the "Logorithmic Scale" box checked, and here's the problem: Only the series on the primary virtical axis is affected. Since there's only one horizontal axis, both series should be affected, but the curve for hte series on the secondary axis remains exactly the same, rendering it incorrect and useless.
I've attached an example using dumbed down data to illustrate the point.
Thanks for your help.
Bookmarks