Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2006

Tip: Looking for answers? Try searching our database.

change minimum and maximum on logarithmic scale chart in excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jbesr1230 - 07 Jun 2006 17:34 GMT
Hello All,
I using a logarithmic scale for an excel chart.  The chart axis is not
"taking" the changes I am putting in for maximum and minimum.  Always
resets to "100,000" and "10,000,000".  The data points in the chart are
between 1,500,000 and 2,500,000.  Thus the majority of the chart plot
space is "wasted".  I would like to reset the maximum to 2,500,000 and
the minimum to 1,000,000 and still have it presented on logarithmic
scale.

Any help or work arounds would be greatly appreciated.

Thanks,

JB
Puppet_Sock - 07 Jun 2006 18:05 GMT
> Hello All,
> I using a logarithmic scale for an excel chart.  The chart axis is not
[quoted text clipped - 6 lines]
>
> Any help or work arounds would be greatly appreciated.

Log scales have to be steps of times 10.

All I can suggest is to multiply your data by some value, then
put a note "data times 3" or whatever on the graph.
Socks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.