PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?bGVz?=
Guest
Posts: n/a
 
      8th Sep 2005
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?
 
Reply With Quote
 
 
 
 
Jon Quixley
Guest
Posts: n/a
 
      8th Sep 2005

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

 
Reply With Quote
 
MrShorty
Guest
Posts: n/a
 
      8th Sep 2005

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

 
Reply With Quote
 
Tushar Mehta
Guest
Posts: n/a
 
      8th Sep 2005
In article <853978B9-347C-4EA9-B03C-(E-Mail Removed)>,
(E-Mail Removed) 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw chart: log scale on X axis, natural scale on y axis? =?Utf-8?B?UHJhdGFwIEQuIGNoYXZhbg==?= Microsoft Excel Charting 1 16th Nov 2006 08:03 AM
Change the value axis scale =?Utf-8?B?U0o=?= Microsoft Excel Charting 2 24th Jan 2005 07:17 PM
how do you split the scale (x-axis) on a curve graph? =?Utf-8?B?dmFsZXZhbDEwMDA=?= Microsoft Excel Charting 1 11th Jan 2005 01:18 PM
I want to produce a log-log chart. Logrithmic scale on both axis. =?Utf-8?B?dHJhbnNjbw==?= Microsoft Excel Charting 2 3rd Jan 2005 02:01 AM
Scaleable logrithmic Y axis Rolls Microsoft Excel Charting 1 12th Nov 2003 11:33 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:34 PM.