Hi there,

I have the results for a survey that I need to analyse and what I want to do is use the pivot table to develop a chart paste it into the word document report then go back to the pivot table and look at a different question or something. My issue is that I cannot stop it from changing the table in word every time change the pivot table. I would like to keep the functionality of the graph in word in case I need to add anything , axis title, legend etc so I don't really wnat to paste it in as a picture but would prefer not to try and manage a pile of different pivot tables and graphs too.

Any ideas

Cheers