Thread: Trendlines in Pivot charts

Can anyone tell me how to add a trend line into a Pivot chart? I have searched the forums and the internet unsuccessfully. Can anyone help me?

Thanks

Paul.

Thank would explain a lot. I actually just pasted the Pivot Data into seperate sheets and then used the ordinary chart functions to get what I needed in the end.

Shame though as the F11 in the tabel feature would have been a real time saver if you had the same functionality.

Thanks for your response.

Paul.