View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
C Tate
 
Posts: n/a
Default Location of pivot chart

I am using Excel 2003. I want to create a pivot chart from a pivot table. As
soon as I click the chart button, however, Excel immediately creates the
chart in a sheet of its own. I want to be able to create that chart in an
existing sheet. I can't see an easy way to do this, other than then moving
the one that's been created on its own chart sheet. Surely there must be a
way to bi-pass that step?