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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks