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?
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?
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
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?
In article <853978B9-347C-4EA9-B03C-3AFC85AA770B@microsoft.com>,
les@discussions.microsoft.com 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks