Create separate pivot chart for each filter


R

RTMI

In Excel, Pivot Charts - When filtering in a pivot table, how do you create a
separate chart for each filtered set of data? As it is now, the chart updates
when you change the filter criteria.
 
Ad

Advertisements

C

Christopher Scott [MSFT]

There's not a way to do this from what I know. You would need to create a
separate pivot table and pivot chart for each filter/view.

If you don't need to keep your pivot chart updating with the pivot table and
just want a few "snapshots", you could filter the pivot table the way you
want, then copy and paste the chart to a new workbook to "unlink" the chart
from the pivot table.
 
X

x Saed

i've been tinkering with 2007 to unlink a pivot chart from a pivot table. I know how to do that in 2003, but i suppose i didn't manage to find equivalent procedure in excel 2007...

the workaround, using paste as picture is not good enough, because the it cannot be edited anymore

Pls help



chscot wrote:

There's not a way to do this from what I know.
14-Feb-08

There's not a way to do this from what I know. You would need to create a
separate pivot table and pivot chart for each filter/view

If you don't need to keep your pivot chart updating with the pivot table and
just want a few "snapshots", you could filter the pivot table the way you
want, then copy and paste the chart to a new workbook to "unlink" the chart
from the pivot table
--
Thanks
Christophe

This posting is provided "AS IS" with no warranties, and confers no rights.

:

Previous Posts In This Thread:

Create separate pivot chart for each filter
In Excel, Pivot Charts - When filtering in a pivot table, how do you create
separate chart for each filtered set of data? As it is now, the chart update
when you change the filter criteria.

There's not a way to do this from what I know.
There's not a way to do this from what I know. You would need to create a
separate pivot table and pivot chart for each filter/view

If you don't need to keep your pivot chart updating with the pivot table and
just want a few "snapshots", you could filter the pivot table the way you
want, then copy and paste the chart to a new workbook to "unlink" the chart
from the pivot table
--
Thanks
Christophe

This posting is provided "AS IS" with no warranties, and confers no rights.

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Reflection Effect
http://www.eggheadcafe.com/tutorial...-beab-49bd76e20b9b/wpf-reflection-effect.aspx
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top