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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______




"excelbanker" wrote in message
...
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?