Re: How to show recent a 3 months regression line in a 12 months bar chart
Ok. So I created a combo chart. Bars are showing the cash payments and the line is showing the linear trend for the last three months. I also put a straight table showing the formula and the trend lines in numeric values:
The formula for the trend line is:
I am attaching the app.
Hope this answers all of your questions and fits into your needs.