1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Format Y axis on a Chart

Discussion in 'Discuss Data Visualizations and Charting' started by Lasantha, Sep 18, 2018.

  1. Lasantha

    Lasantha Member

    Messages:
    92
    Dear All,

    Could you please help me to get exact values on Y Axis. Please see the attached file.

    i need 198, 390, 430, ........on Y axis.

    Thank you.

    Attached Files:

  2. Syedali

    Syedali Active Member

    Messages:
    281
    Ok What you going to show in X Axis
  3. Lasantha

    Lasantha Member

    Messages:
    92
    A,B,C,D,....
  4. Peter Bartholomew

    Peter Bartholomew Active Member

    Messages:
    413
    To the best of my knowledge what you have asked for is not possible.
    What I have done in the attached file is to include a dummy series based upon your data and label the points to their left.

    Attached Files:

    Thomas Kuriakose and Lasantha like this.
  5. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,568
    upload_2018-9-19_18-41-40.png
    Using Peter's technique
    Thomas Kuriakose and Lasantha like this.
  6. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,568
    or adding a few more series
    upload_2018-9-19_18-51-2.png

    see attached file

    Attached Files:

  7. Peter Bartholomew

    Peter Bartholomew Active Member

    Messages:
    413
    I like the 'grid' lines :cool:
  8. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,568
    and they are dynamic

  9. Lasantha

    Lasantha Member

    Messages:
    92
    Thank you

Share This Page