PC Review

Thread Tools Rate Thread

Link PivotChart to PivotTable, whilst hiding fields

Posts: n/a
      3rd Mar 2009
My problem is simple:
I have a pivottable that displays data in several columns based on filters.
I have a pivotchart based on this pivottable.
The pivotchart displays ALL data from the pivottable.
I want to remove one of the value fields that is displayed on the
PivotChart, but I seem to only be able to do this if I alter the underlying
PivotTable which is unacceptable.

I read one guide online that mentioned creating a second PivotTable "based
on" the first one and using this to create the PivotChart. I've also tried to
do a dynamic named range but this only resulted in me wanting to kill small
animals. (I couldn't get it to work at all)

This seems like it should be a very common problem...any ideas?
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Link PivotChart to PivotTable, whilst hiding fields clifgriffin Microsoft Excel Programming 0 3rd Mar 2009 08:03 PM
Duplicating PivotChart / Changing PivotChart data range BillG Microsoft Excel Charting 0 4th Feb 2009 09:56 PM
Hiding and Un-Hiding Data fields ROL41 Microsoft Access Forms 5 7th Jan 2008 08:31 PM
Hiding columns whilst autofiltered - PART 2 HELP!!! =?Utf-8?B?UEcgT3JpZWw=?= Microsoft Excel Programming 1 9th Oct 2006 12:21 AM
Force pivotchart view when opening a pivotchart form =?Utf-8?B?dHNpc29uNw==?= Microsoft Access 0 27th Jun 2006 11:31 AM




All times are GMT +1. The time now is 01:18 PM.