Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting x axis values on bottom in a logarithmic scale chart | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
how can I make a chart with the x-axis in logarithmic scale | Charts and Charting in Excel |