How do I change the scale of logrithmic curve on the x-axis?

L

les

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?
 
J

Jon Quixley

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
 
M

MrShorty

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?
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top