Comments on: How to add a line in Excel graph (average line, benchmark, baseline, etc.)

In situations when you want to compare the actual values with the target you wish to achieve, you can draw a horizontal line in your Excel graph such as an average line, baseline or target line. This can be done by combining two different chart types in the same graph. Continue reading →

Table of contents

Comments page 2. Total comments: 30

  1. Hi all,

    How to make trend line upto few bars in excel chart. I do not want trend line for entire bars what ever available in chart.
    Regards,
    Harinath

  2. I can't get the last bit of your tutorial to work (Extending the line to the edges of the chart data). I did as you said but my axis labels are not lined up (i.e. the first label for the first bar with values in it is actually lined up with the empty bar beside it).

    1. Never mind, got it to work!

      1. HI,
        Can you share your work around ?
        I am facing the same issue

  3. Hello, Amit.

    Unfortunately, there is no way to move this line manually. However, if you change the values it refers to, it will be moved to the corresponding position automatically.

    Please let us know if you have any other questions.

  4. can i put this line anywhere. I want this line to be moved from current location to other location. Is it possible. Please let me know. 9958612547

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)