Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change the scale of logrithmic curve on the x-axis?
I would like to reduce the x-axis range on a logrithmic curve from 10 to 50,
but I am restricted to a scale of 10 to 100? |
#2
|
|||
|
|||
A logarithmic scale by definition goes up in decades. You have to use multiples of 10, by this I mean 0.01, 0.1, 1, 10, 100, 1000 etc. You cannot use anything else -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=465768 |
#3
|
|||
|
|||
It's true that Excel's chart engine is limited in this way, but I have seen other graphing programs that do allow you to set logarithmic scales to other than integer powers of 10. Are you in a position to use logarithms on a regular scale (instead of actual values on a logarithmic scale) for your X values? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=465768 |
#4
|
|||
|
|||
In article ,
says... I would like to reduce the x-axis range on a logrithmic curve from 10 to 50, but I am restricted to a scale of 10 to 100? To simulate the effect see Flexible Log Scale http://www.tushar- mehta.com/excel/newsgroups/flexible_log_scale/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the scale of the catagory axis? | Charts and Charting in Excel | |||
watch a curve change over time like a movie | Charts and Charting in Excel | |||
how do you split the scale (x-axis) on a curve graph? | Charts and Charting in Excel | |||
I want to produce a log-log chart. Logrithmic scale on both axis. | Charts and Charting in Excel | |||
Change Axes Scale Dynamically | Charts and Charting in Excel |