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?

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