pivot charts

  • Thread starter Thread starter jimmy
  • Start date Start date
J

jimmy

I was wondering if it was possible to create a pivot chart
based off of a pivot table. And on the sheet that the
chart is created to have another pivot chart or just a
text box. I know that the pivot chart is created on a
seperate worksheet but i dont know if its possible to have
another chart or text box on that worksheet, any ideas
would be great thanks a lot...
 
I suspect you could cut and paste to create what you want. I doubt there is
a limitation on two charts on the same sheet if you mean worksheet. If you
mean chart sheet, I believe that can be done as well.
 
Jimmy -

By default, pivot charts are built as stand alone chart sheets.
Probably to mask their very small and unchangeable plot area size. But
you can move a pivot chart onto another sheet.

Right click on the pivot chart, choose Location from the pop up menu,
click the As Object In option, and pick a sheet name. This embeds the
chart in another sheet (worksheet or chart sheet), and you can have
multiple charts (pivot charts or real charts) on one sheet.

- Jon
 
Back
Top