Hello,

I need to delete each series of my Pivot Chart that contains the word "Max", but, when the word TOTAL is also on the same series name text, it cannot be deleted. For example I have the following series:

*PHYSCAL - Max of Box_MIPS_Capacity
TOTAL - Max of Box_MIPS_Capacity
XPTO - Max of Box_MIPS_Capacity


So, basically it needs to delete two of the above:
*PHYSCAL - Max of Box_MIPS_Capacity and XPTO - Max of Box_MIPS_Capacity. The other one TOTAL - Max of Box_MIPS_Capacity must remain on the chart.

Can Anyone help me please?


I am trying the following code:
Please Login or Register  to view this content.
It also gives me an error saying "Run-time error '1004' Application-defined or object-defined error". Looks like it is not supported for PivotChart, because with normal chart it does work.

Thanks.