How do I add a horizonal target/goal line to a line chart?

[excelbanker]

I am trying to add a horizontal target/goal line to a line chart that
contains two other data series. How do I add the line without including it
in my data table that includes both data labels and legend keys?

 

[Andy Pope]

Hi,

The data table will include all data series.
With the legend you can select the individual legend entry and delete it.

Adding datum lines
http://www.andypope.info/charts/averageline.htm

Deleting legend entries
http://www.andypope.info/charts/deletelegendentry.htm

Cheers
Andy

 

[Jon Peltier]

Make the chart with all of the series, including the goal line. Make sure
the target is the last series in the chart. Add the data table, so Target is
the lowest in the table. Use a simplified formatting for the data table, for
example, only use horizontal internal borders. Then go to the worksheet, and
change the number format of the target cells to ;;; which will suppress
their appearance in the worksheet and in the data table.


- Jon