chart appears grey box when try and copy and paste

Hi all,

I have copied and pasted a pivot chart from one sheet into another in excel, but the new chart appears greyed out.

If I click on the greyed out box the chart appears but if i click somewhere else the box goes grey again

Does anyone know how to overcome this problem?

Many thanks,

Nicko

thanks Andy!

thats solved it