I Am try to show trend in combo chart. trend line is last 6 weeks avg. for example today Friday I want to show last 6 Fridays avg, for Thursday last 6 Thursdays like that. last 6 weeks same day avg.
I hope I explained clearly in initial question, manually I preparing data is tough. I will try to explain my expected output.
In combo chart bars are actuals every day sum, trend line I want show last 6 weeks same day (if today is Tuesday last 6 Tuesdays avg , Mondays like that ) avg. in initial question I have posted sample combo chart
