Results 1 to 2 of 2

Thread: How to add straight line in a chart in Excel 2007

  1. #1
    Join Date
    Jan 2011
    Posts
    12

    How to add straight line in a chart in Excel 2007

    Can anyone tell me how would I go about adding a horizontal line to a chart. I am trying to make a line chart and need to place a horizontal line at 80% across the entire chart. How can I do this. Thanks for any information

  2. #2
    Join Date
    Jul 2011
    Posts
    440

    Re: How to add straight line in a chart in Excel 2007

    You need to go to Insert / Illustrations group / Shapes / Line - draw across at 80% mark. In the same way you can insert a object inside the chart. If you want to do that in chart itself then you will need to create one more value and with common numbers assign to each.

Similar Threads

  1. Help needed to add a Chart with a macro in Excel 2007
    By Clemens in forum Windows Software
    Replies: 3
    Last Post: 19-11-2010, 12:31 AM
  2. Hiding zero values on a chart in Excel 2007
    By mellisahi in forum Windows Software
    Replies: 4
    Last Post: 12-11-2009, 09:37 AM
  3. Excel 2007 chart templates
    By raviranch in forum Windows Software
    Replies: 2
    Last Post: 13-07-2009, 01:30 PM
  4. Mark data points in Excel line chart
    By Amie in forum Windows Software
    Replies: 3
    Last Post: 11-06-2009, 07:50 PM
  5. How to lock Chart in Excel 2007
    By Durjaya in forum Windows Software
    Replies: 3
    Last Post: 08-05-2009, 03:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,567,080.80562 seconds with 18 queries