the trendline is tied to the series, so I suspect you are changing the
series and thus losing the line. Unless you write a macro to reestablish
it, I think not.

--
Regards,
Tom Ogilvy

"Tony" wrote in message
...
I have a multi Series Chart based on an OLAP Pivot table.

I have a Trend Line based on one of the series.

Each time I filter the data on the chart (for example selecting a
different
date on the Y axis), the trend line disappears. Is there anyway to stop
this happening?

Thanks in advance

Tony