Share via

Log scale y axis

Anonymous
2014-08-22T16:41:57+00:00

How do I show the values on the y axis when using log scale.  The chart I am creating only show one value when I go to log scale.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.8K Reputation points Volunteer Moderator
2014-08-22T17:03:20+00:00

The logarithmic scale will always show on the basis of base and major and minor

If base is 10, then minimum major and minor accepted will be 10 each.

--- 1, 10, 100, 1000, 10000

If base is 2, minimum major and minor accepted will be 2 each.

-- 1, 2, 4, 8,16...

Similarily, you can experiment with other base, major and minor..

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-03-15T09:35:06+00:00

    Well, that's ****, I want different major and minor scales!!

    Was this answer helpful?

    0 comments