How to plot data in Excel with axes using logarithmic scaling?

See the axis of this chart

image

As I marked the axis with red oval, the axis is flocused toward the main bounds. How can I plot such a chart?

4

1 Answer

Based on your comments, the specific thing you're looking for is plotting with a log scale. I made a simple example with some data that would be close to a straight line on a log scale, and didn't bother matching the other formatting in your example:

enter image description here

The two axes are similar. My settings for the X axis are shown. I also turned on minor grid lines on both axes. The Excel I had handy was v2007, so the dialog window might look a little different from yours.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like