Create separate pivot chart for each filter
 

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.

Create separate pivot chart for each filter
 

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,
Christopher

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


"RTMI" wrote:

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.

how to that in 2007
 

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,
Christopher

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


"RTMI" wrote:

Previous Posts In This Thread:

On Wednesday, February 06, 2008 11:01 AM
RTM wrote:

Create separate pivot chart for each filter
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.

On Thursday, February 14, 2008 10:33 PM
chscot wrote:

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,
Christopher

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


"RTMI" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Reflection Effect
http://www.eggheadcafe.com/tutorials...on-effect.aspx

how to that in 2007
 

How do you do that in 2003?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/3/2010 12:55 AM, x Saed wrote:
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.