software

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?
Making a pivot chart doesn't take you through the full-blown chart wizard,
which allows this choice on its last step. I can't think of a non-VBA way to
put a pivot chart directly onto a worksheet (and I spent almost a minute
trying!).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;C Tatequot; gt; wrote in message
...
gt;I am using Excel 2003. I want to create a pivot chart from a pivot table.
gt;As soon as I click the chart button, however, Excel immediately creates the
gt;chart in a sheet of its own. I want to be able to create that chart in an
gt;existing sheet. I can't see an easy way to do this, other than then moving
gt;the one that's been created on its own chart sheet. Surely there must be a
gt;way to bi-pass that step?
gt;