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.

Creating Horizontal Line in Excel Graphs (Office 2007)

Discussion in 'Ask an Excel Question' started by Sree Harsha, Nov 14, 2017.

  1. Sree Harsha

    Sree Harsha New Member

    Messages:
    3
    Hello,

    I have been trying to add a horizontal line (Target) for an existing graph in Excel. I have done this in the past using Office 2011, 2013 & 2016. However for some reason the steps i am using is not working in 2007. Any help is much appreciated.

    Please find attached for details.

    Thanks in advance!

    Attached Files:

  2. vletm

    vletm Well-Known Member

    Messages:
    2,854

    Attached Files:

  3. Sree Harsha

    Sree Harsha New Member

    Messages:
    3
    Hi,

    Thanks for your reply.

    Not exactly what i was looking for, below is what i need.

    upload_2017-11-14_17-19-35.png
  4. Lasantha

    Lasantha Member

    Messages:
    39
    Hi,
    Please see attached file.

    Attached Files:

  5. vletm

    vletm Well-Known Member

    Messages:
    2,854
    Sree Harsha
    Okay ...
    Screen Shot 2017-11-14 at 15.22.06.png
    Your newer data is different ... not challenge ... !
    If You really would like to get that kind of layout,
    then here You are.

    Attached Files:

    sathishsusa likes this.
  6. Sree Harsha

    Sree Harsha New Member

    Messages:
    3
    Hey..

    Thanks for the response.

    Like I mentioned in my post, I have no trouble creating this graph in office 2013 or 2016 but I am having a tough time doing this on office 2007. Let me know if you are able to do it in office 2007. Thanks..
  7. vletm

    vletm Well-Known Member

    Messages:
    2,854
    Maybe there are some differences between versions of Excel.
    I don't have challenges if just need specific layout.
    It just needs to find out, how to do it.
    I will let You know, if I would have Excel 2007-version and
    if there would be some challenges.
    ps Why to need to use ... three different versions of Excel?

Share This Page