ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   extra trendline on Pivot Chart (https://www.excelbanter.com/charts-charting-excel/94012-extra-trendline-pivot-chart.html)

[email protected]

extra trendline on Pivot Chart
 
I know you can add extra trendlines to a pivot chart through VBA. But
can I change all of the intercepts? Basically I want to add 2
additional "trendlines" showing an acceptable range of +/- 20%. I see
that there is an intercept method/property, but this seems to only
change the initial X intercept, I want to change all of them. Any
suggestions? Is this even possible on a pivot chart?



All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com