Share via

How do I set the horizontal axis to a log scale?

Anonymous
2011-04-19T15:11:44+00:00

I am trying to do a log-log plot in Excel 2010 and have not found a way to make the x axis be in 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
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2011-04-19T16:03:06+00:00

    You have to use a scatter (XY) chart to be able to make the X-axis logarithmic. It is the only chart type with a numeric X-axis instead of a category X-axis.

    100+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-01-25T06:05:48+00:00

    You have to use a scatter (XY) chart to be able to make the X-axis logarithmic. It is the only chart type with a numeric X-axis instead of a category X-axis.

    This hint has helped me when I was in a difficult situation of making X-Axis as a log scale. After you made the graph with points only, then make the lines. Thanks a lot

    10 people found this answer helpful.
    0 comments