×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Log plots & maximum for "y"

Log plots & maximum for "y"

Log plots & maximum for "y"

(OP)
Refining Excel results...
Hi, colleagues
Sometimes, making a plot in Excel, we may prefer a logarithmic graphic. This is an option using the Excel wizard for a graphic.
But trying to define the maximum value for the "y" variable, Excel increases such muber to the log decade immediatly up.
I mean, if you put 5000 as the maximum for the "y" axis, Excel will show 10000 as the maximum.
This is different if a linear scale is selected, Excel will show in the graph any number you establish as the maximum.
Does anybody know if there is a trick to obtain what I described, id est, a graph showing 5000 (or any number different to 1; 10; 100; 1000; 10000, etc.)?

Have a safe day
Jorge Alvarez

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources