Hi,

I have two sets of data and I am plotting both on the same chart. I need
them to have separate y axes, because they have different ranges. When I
select one data set and force it onto a secondary y-axis, it stops plotting
on the log-x axis, and instead plots over an imaginary linear x axis. So,
for instance, value x=4871 y=1.29 plots at 1.29 on the secondary y axis and
at about 900 on the log x axis. Anyone know of a fix?

Thanks
-Tom

Paste your data into a response to this post, both sets of data, so we can
better understand the problem.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"tom r" wrote in message
...
Hi,

I have two sets of data and I am plotting both on the same chart. I need
them to have separate y axes, because they have different ranges. When I
select one data set and force it onto a secondary y-axis, it stops
plotting
on the log-x axis, and instead plots over an imaginary linear x axis. So,
for instance, value x=4871 y=1.29 plots at 1.29 on the secondary y axis
and
at about 900 on the log x axis. Anyone know of a fix?

Thanks
-Tom

Hi,

What version of xl are you using.
In 2003 an xy scatter with Log x axis appears to maintain secondary log x
axis when a series is moved to secondary y axis.

In 2007 the secondary x axis is linear. To change this select the chart and
set Layout Axes Axes Secondary Horizontal Axis Show Axis with log
scale.

If this does not solve the problem do as Jon suggests and post a sample data
set and let us know which xl version you are using.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"tom r" wrote in message
...
Hi,

I have two sets of data and I am plotting both on the same chart. I need
them to have separate y axes, because they have different ranges. When I
select one data set and force it onto a secondary y-axis, it stops
plotting
on the log-x axis, and instead plots over an imaginary linear x axis. So,
for instance, value x=4871 y=1.29 plots at 1.29 on the secondary y axis
and
at about 900 on the log x axis. Anyone know of a fix?

Thanks
-Tom