Hi Andy,

Thank you so much! This is perfect.

Lisa

"Andy Pope" wrote:

Hi,

Rather than remove the series that the trend line is based upon format it to
have no markers or line colour.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"FlexoC" wrote in message
...
Is it possible to add a trend line to a chart but remove the data line
from
view and still keep the data available on the chart?