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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"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?