How to Create Target Lines in Excel Charts

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create Target Lines in Excel Charts
(Polka Dot RF/Polka Dot/Getty Images)

A target, or goal line, is an imaginary horizontal line on a chart that represents a certain level of performance. For example, in a chart for academic performance, the target line might be set at the typically passing grade of 70 per cent. The target lines gives a viewer a quick visual way to see how many items on the chart are underperforming and how many are over-performing. While Excel doesn't have a menu option to add a horizontal line, you can make a horizontal line on your chart by adding a dummy series.

Skill level:
Moderately Challenging

Things you need

  • Existing chart data in Excel 2007 or Excel 2010

Show MoreHide


  1. 1

    Locate the chart data on your Excel worksheet. If you aren't sure which data was used for the chart, click once on the chart: the chart data will be bordered by a blue line on the worksheet.

  2. 2

    Click on the first blank cell to the right of your chart data. If you don't have a blank column directly to the right of your chart data, create one: right click, then click "Insert" and then click "Entire column."

  3. 3

    Type your target. For example, if your graph consists of sales figures and your target sales goal is 20 units, type "20."

  4. 4

    Click the fill handle for the cell. The cell looks like a little black square at the bottom right of the cell. Drag it down the column to the last row in your chart data. This action copies the input for the cell (in this example, 20) to all cells in the column. This is the dummy series for your chart.

  5. 5

    Highlight the entire chart data area, including the dummy series. To highlight the data, left click at the top left of the cells and then drag the cursor to the bottom right.

  6. 6

    Click the "Insert" tab. Select the chart type you want displayed. For example, click "Column" and then click "2D." Excel will insert the chart into the spreadsheet.

  7. 7

    Click the dummy series on the chart, then click "Change Chart Type." Change the chart type to "Line."

Tips and warnings

  • If it's inconvenient to add an entire column to the right of your data, copy your chart data to the very bottom of your spreadsheet before adding the dummy data.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.