Hi,

Is is possible to add a trend line to a pivot table chart, I have tried
upgrading to Excel 2007 and I still can't get it to work, I have tried to
take the info from the table and use an average formula but when the number
of data entries changes it means that I have to change the formula as I dont
want the total figure in there.

I am hoping it is possible to get this aveage line in somehow

Thanks