Pivot chart problem

[C Tate]

I have created a pivot table in my spreadsheet. I now want to create a pivot
chart from that pivot table. However, I don't want it to be automatically
stuck in a sheet of its own. I want to put in in cell c2 of an existing
sheet. How do I do this?

 

[Debra Dalgleish]

After you create the pivot chart, right-click on it, and choose Location
From the 'As object in' dropdown, select a worksheet
Click OK