Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

Creating graphics based on Pivot Table

Posted by Dominique De Beys on December 27, 2001 6:07 AM

Dear all,

I would like to create a pie chart based on a pivot table. Unfortunately, I don't want to use the pivot chart utility. The results I got when I used pivot chart was not good enough.

Can you help me to create a "nice" graphic based on a pivot table without using the pivot chart utility?

Thanks for your help,

Dominique

Re: Creating graphics based on Pivot Table

Posted by Mike on December 27, 2001 12:27 PM

I am looking for a more elegant solution to this problem too, but what I am doing in the mean time is to paste the data to another sheet (Paste Special with the Values option selected or you just get another pivot table) and building my chart from that. I will probably end up writing a macro to copy the data automatically later.

Good luck...Mike

Re: Creating graphics based on Pivot Table

Posted by Chris D on December 27, 2001 4:19 PM

Mike, I sometimes create my own pivot table using "sumif"s...... it saves time creating the pivot table then copy paste special values somewhere..... could this help ?

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.