Chart distorts secondary axis when the x-axis is logarithmic
I'm trying to create a chart whose x-axis and primary y-axis are logarithmic
and whose secondary y-axis is linear using Excel 2007. No matter how I build the chart (i.e. three columns at the same time, or adding a series at a time) as soon as I select logarithmic from the x-axis options the data plotted on the y-axis ( the linear axis) becomes distorted (logarithmic). How can I correct this? Thanks for your help. |
Chart distorts secondary axis when the x-axis is logarithmic
Hi,
I can not reproduce the problem. All is as expected if I, Create a xy-scatter with 2 series. Move 2nd series to Secondary axis. Change Primary Y axis to Log Change Primary X axis to Log Do you have Service Pack 2 installed? Check via Office Button Excel Options Resources. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nemo" wrote in message ... I'm trying to create a chart whose x-axis and primary y-axis are logarithmic and whose secondary y-axis is linear using Excel 2007. No matter how I build the chart (i.e. three columns at the same time, or adding a series at a time) as soon as I select logarithmic from the x-axis options the data plotted on the y-axis ( the linear axis) becomes distorted (logarithmic). How can I correct this? Thanks for your help. |
Chart distorts secondary axis when the x-axis is logarithmic
Thanks for you help Andy, but I still get the same results when I perform the
steps of your solution. I checked and verified that we have SP2 loaded. Before I posted my question yesterday I sent my file to one of our Excel "experts" here and he got the same result I did. After I read your response I gave the file to one of our engineer "new hires" (fresh out of college). He also was unable to correctly plot this data with a logarithmic x-axis, primary y-axis and linear secondary y-axis. If you have time could I send you the worksheet I'm trying to put into a chart? "Andy Pope" wrote: Hi, I can not reproduce the problem. All is as expected if I, Create a xy-scatter with 2 series. Move 2nd series to Secondary axis. Change Primary Y axis to Log Change Primary X axis to Log Do you have Service Pack 2 installed? Check via Office Button Excel Options Resources. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nemo" wrote in message ... I'm trying to create a chart whose x-axis and primary y-axis are logarithmic and whose secondary y-axis is linear using Excel 2007. No matter how I build the chart (i.e. three columns at the same time, or adding a series at a time) as soon as I select logarithmic from the x-axis options the data plotted on the y-axis ( the linear axis) becomes distorted (logarithmic). How can I correct this? Thanks for your help. . |
Chart distorts secondary axis when the x-axis is logarithmic
Hi,
send the file to andy AT andypope DOT info Cheers Andy Nemo wrote: Thanks for you help Andy, but I still get the same results when I perform the steps of your solution. I checked and verified that we have SP2 loaded. Before I posted my question yesterday I sent my file to one of our Excel "experts" here and he got the same result I did. After I read your response I gave the file to one of our engineer "new hires" (fresh out of college). He also was unable to correctly plot this data with a logarithmic x-axis, primary y-axis and linear secondary y-axis. If you have time could I send you the worksheet I'm trying to put into a chart? "Andy Pope" wrote: Hi, I can not reproduce the problem. All is as expected if I, Create a xy-scatter with 2 series. Move 2nd series to Secondary axis. Change Primary Y axis to Log Change Primary X axis to Log Do you have Service Pack 2 installed? Check via Office Button Excel Options Resources. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nemo" wrote in message ... I'm trying to create a chart whose x-axis and primary y-axis are logarithmic and whose secondary y-axis is linear using Excel 2007. No matter how I build the chart (i.e. three columns at the same time, or adding a series at a time) as soon as I select logarithmic from the x-axis options the data plotted on the y-axis ( the linear axis) becomes distorted (logarithmic). How can I correct this? Thanks for your help. . -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Chart distorts secondary axis when the x-axis is logarithmic
Did you ever succeeded.
I have now the same problem with Microsoft Excel 2007. I have two curves with big difference in y-axis but same values in x-axis. I wanted to plot the curves with y-axis as linear axis for both primary and secondary axis and x-axis as logarithmic axis for both as well. Whenever I change x-axis to logarithmic only primary curve changes while the secondary axis remain in same place (still is linear in x-axis). "Andy Pope" wrote: Hi, send the file to andy AT andypope DOT info Cheers Andy Nemo wrote: Thanks for you help Andy, but I still get the same results when I perform the steps of your solution. I checked and verified that we have SP2 loaded. Before I posted my question yesterday I sent my file to one of our Excel "experts" here and he got the same result I did. After I read your response I gave the file to one of our engineer "new hires" (fresh out of college). He also was unable to correctly plot this data with a logarithmic x-axis, primary y-axis and linear secondary y-axis. If you have time could I send you the worksheet I'm trying to put into a chart? "Andy Pope" wrote: Hi, I can not reproduce the problem. All is as expected if I, Create a xy-scatter with 2 series. Move 2nd series to Secondary axis. Change Primary Y axis to Log Change Primary X axis to Log Do you have Service Pack 2 installed? Check via Office Button Excel Options Resources. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nemo" wrote in message ... I'm trying to create a chart whose x-axis and primary y-axis are logarithmic and whose secondary y-axis is linear using Excel 2007. No matter how I build the chart (i.e. three columns at the same time, or adding a series at a time) as soon as I select logarithmic from the x-axis options the data plotted on the y-axis ( the linear axis) becomes distorted (logarithmic). How can I correct this? Thanks for your help. . -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info . |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com