Trend Line Disappears

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>