A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Create separate pivot chart for each filter



 
 
Thread Tools Display Modes
  #1  
Old February 6th, 2008, 05:01 PM posted to microsoft.public.excel.charting
RTMI
external usenet poster
 
Posts: 1
Default 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.
  #2  
Old February 15th, 2008, 04:33 AM posted to microsoft.public.excel.charting
Christopher Scott [MSFT]
external usenet poster
 
Posts: 27
Default 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.

  #3  
Old May 3rd, 2010, 05:55 AM posted to microsoft.public.excel.charting
x Saed
external usenet poster
 
Posts: 1
Default 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
  #4  
Old May 3rd, 2010, 05:40 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.