C
clifgriffin
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?
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?