Trend Line Disappears

[Tony]

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

 

[Tom Ogilvy]

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.