Thread: How to add PivotTable drop down selector to another tab?
View Single Post
  #31 (permalink)  
Old 01-29-2008, 06:35 AM
BurgoEng BurgoEng is offline
Junior Member
  
Join Date: Oct 2007
Posts: 28
iTrader: (0)
BurgoEng is on a distinguished road
Default
In the PivotChart, right click and select Location and select Object in and select the SHEET you want the chart embedded in.
Reply With Quote