Converting to Log scale with primary and secondary y axes

[alexg]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

The issue I am having is as follows: My data plots nicely in the chars x-y scatter format, I two sets of data with a common x-axis but two y-axes (primary and secondary). At this point everything looks good. However when I go to change the format of the horizontal axis to logarithmic the only curve that refits to the log axis is the data set with the primary y-axis. The set with the secondary y-axis does not convert its horizontal data to the log scale and hence the problem. Any help is appreciated.

thanks

alexg

 

[docruss]

Version:2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

The issue I am having is as follows: My data plots nicely in the chars x-y scatter format, I two sets of data with a common x-axisbut two y-axes (primary and secondary). At this point everything looks good. However when I go to change the format of the horizontalaxisto logarithmic the only curve that refits to thelogaxisis the data set with the primary y-axis. The set with the secondary y-axisdoes not convert its horizontal data to thelogscaleand hence the problem. Any help is appreciated.

thanks

alexg

I am having the exact same problem and could not find the option to
fix it. I just rescaled my data so they could be on the same y-axis.
However if someone knows the right way to do this please let us know.

Thanks

 

[Mayank Gupta]

Hi Russell,

I had the same problem, but I have found the solution.
In MS excel 2007, the secondary y-axis has its own secondary x-axis.
you can change its properties by
selecting the chart and
set Layout > Axes > Axes > Secondary Horizontal Axis > Show Axis with
log
scale.
there is also any option for "more secondary horizontal axis option"
that opens up all the features to be modified.
hope that helps.

mayank