Jul 15 2020 03:46 AM
Hi, I'm trying to compare 5 years of data on a graph is there anyway a trendline can be applied without it being a year specific?
I am wanting to track an average based on value of performance?
Thanks in advance. :)
Jul 19 2020 12:03 AM
Hi @Cazza362001
You data source need to update with monthly average and you need to select the only average line while creating the graph, pls attached the same file if you are not able to resolve the issue
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more