software

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:
gt; I have created a pivot table in my spreadsheet. I now want to create a pivot
gt; chart from that pivot table. However, I don't want it to be automatically
gt; stuck in a sheet of its own. I want to put in in cell c2 of an existing
gt; sheet. How do I do this?
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html