Putting a pivot field in the Value Field - Macro - Pivot Charts

Hi there

Here is a simple bit of code that basically goes through the 2 pivot charts and puts the pivot field “#3” in the legend field(xlColumnField) in position 2

Now what I want to be able to do is put it in the Values field.

Any ideas how this can be done?

Please Login or Register  to view this content.

I have tried doing something like, "Sum of #3", xlSum taken from below but I cannot seem to get this to work!!

Please Login or Register  to view this content.

Thanks