If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Location of pivot chart
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 http://PeltierTech.com/ _______ "C Tate" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Chart: cannot apply the default chart type... | doco | Charts and Charting | 1 | January 17th, 2005 05:55 PM |
pivot chart format | Valeria | Charts and Charting | 1 | January 14th, 2005 02:19 PM |
Pivot table and buble chart | mbobro | General Discussion | 5 | July 23rd, 2004 08:17 AM |
Chart from Pivot table | Adam | General Discussion | 1 | June 23rd, 2004 12:58 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |