Hi,

For the legend you can delete the entry.
http://www.andypope.info/charts/deletelegendentry.htm

The data table though you have no control over.
Have a look at this though.
http://tushar-mehta.com/excel/newsgr...able/index.htm

Cheers
Andy

TWeaver wrote:
How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?

Any sugestions would be greatly appreciated.