Roy riggsjø
Registered User.
- Local time
- Today, 09:57
- Joined
- Apr 11, 2008
- Messages
- 11
Hello.
Im playing around with the pivot chart to make it dynamic. (VBA)
Ive been searching the web, both here and there to find what im looking for, but without no luck.
So. My case...
I manage to create, open and edit a pivot chart...
So imagine that this basic code is okey.
My problem is around:
.SetData chDimValues, chDataBound, "[Datafield]"
This formula works great for adding ONE datafield to the pivot chart area... but how on earth can i add several fields... i've tried semicolons etc... but maybe not the right one... any one have a trick
.SetData chDimValues, chDataBound, "[Datafield],[Datafield2]," ?????
Thank you experts!
Im playing around with the pivot chart to make it dynamic. (VBA)
Ive been searching the web, both here and there to find what im looking for, but without no luck.
So. My case...
I manage to create, open and edit a pivot chart...
So imagine that this basic code is okey.
My problem is around:
.SetData chDimValues, chDataBound, "[Datafield]"
This formula works great for adding ONE datafield to the pivot chart area... but how on earth can i add several fields... i've tried semicolons etc... but maybe not the right one... any one have a trick
.SetData chDimValues, chDataBound, "[Datafield],[Datafield2]," ?????
Thank you experts!