Pivot Chart - data fields automation (1 Viewer)

Roy riggsjø

Registered User.
Local time
Today, 06:05
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!
 

Users who are viewing this thread

Top Bottom