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





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















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?










share|improve this question

























  • I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.

    – fixer1234
    Jan 30 at 22:41











  • @fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.

    – Roh
    Jan 31 at 6:04











  • That's just plotting on a log scale.

    – fixer1234
    Jan 31 at 6:33











  • @fixer1234 Could you please post your answer with an example?

    – Roh
    Jan 31 at 7:01


















0















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?










share|improve this question

























  • I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.

    – fixer1234
    Jan 30 at 22:41











  • @fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.

    – Roh
    Jan 31 at 6:04











  • That's just plotting on a log scale.

    – fixer1234
    Jan 31 at 6:33











  • @fixer1234 Could you please post your answer with an example?

    – Roh
    Jan 31 at 7:01














0












0








0








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?










share|improve this question
















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?







microsoft-excel charts






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 31 at 7:43









fixer1234

19.6k145083




19.6k145083










asked Jan 30 at 18:26









RohRoh

1084




1084













  • I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.

    – fixer1234
    Jan 30 at 22:41











  • @fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.

    – Roh
    Jan 31 at 6:04











  • That's just plotting on a log scale.

    – fixer1234
    Jan 31 at 6:33











  • @fixer1234 Could you please post your answer with an example?

    – Roh
    Jan 31 at 7:01



















  • I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.

    – fixer1234
    Jan 30 at 22:41











  • @fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.

    – Roh
    Jan 31 at 6:04











  • That's just plotting on a log scale.

    – fixer1234
    Jan 31 at 6:33











  • @fixer1234 Could you please post your answer with an example?

    – Roh
    Jan 31 at 7:01

















I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.

– fixer1234
Jan 30 at 22:41





I see the circles, but it isn't clear to me what aspect you're referring to, or what you mean by "focused" or "main bounds". There are axis tick marks at the grid locations.

– fixer1234
Jan 30 at 22:41













@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.

– Roh
Jan 31 at 6:04





@fixer1234 Please see the grid concentration. The axis tick marks getting close to each other with closing to the main bound. e.g. for "Msupply", from 10^0 to 10^1, the axis tick marks getting close to each other with getting close to 10^1. Did you get what I mean? please feel free to ask your question.

– Roh
Jan 31 at 6:04













That's just plotting on a log scale.

– fixer1234
Jan 31 at 6:33





That's just plotting on a log scale.

– fixer1234
Jan 31 at 6:33













@fixer1234 Could you please post your answer with an example?

– Roh
Jan 31 at 7:01





@fixer1234 Could you please post your answer with an example?

– Roh
Jan 31 at 7:01










1 Answer
1






active

oldest

votes


















2














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.






share|improve this answer
























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1400206%2fhow-to-plot-data-in-excel-with-axes-using-logarithmic-scaling%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    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.






    share|improve this answer




























      2














      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.






      share|improve this answer


























        2












        2








        2







        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.






        share|improve this 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.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 31 at 7:22









        fixer1234fixer1234

        19.6k145083




        19.6k145083






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1400206%2fhow-to-plot-data-in-excel-with-axes-using-logarithmic-scaling%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            "Incorrect syntax near the keyword 'ON'. (on update cascade, on delete cascade,)

            Alcedinidae

            Origin of the phrase “under your belt”?