Pivot chart problem
 

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?

Pivot chart problem
 

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

C Tate wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html