Trendline comparable over 5 sets of data

Occasional Visitor

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.



1 Reply

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