Hi all!
I have a pivot chart that shows sales total by sales person/month, over three years.
It has slicers to select salespeople, years, quarters, types of sale.
I can add a trendline to each of my salespeople, but whenever I use any slicers/change the view of the data, my trendlines disappear:
I want to apply the trendline dynamically, so that regardless of the view my users select, the trend is still calculated and shown. The trendline acts more like formatting than a formula. I want to sort of 'marry' each trendline to each plotted line, if that makes sense?
Thanks in advance for any help!
I have a pivot chart that shows sales total by sales person/month, over three years.
It has slicers to select salespeople, years, quarters, types of sale.
I can add a trendline to each of my salespeople, but whenever I use any slicers/change the view of the data, my trendlines disappear:
I want to apply the trendline dynamically, so that regardless of the view my users select, the trend is still calculated and shown. The trendline acts more like formatting than a formula. I want to sort of 'marry' each trendline to each plotted line, if that makes sense?
Thanks in advance for any help!