Date Category in Pivot Chart (vba)

S

Schor Lars

Hallo!

I will programm a pivot chart with vba. but when i add a category, i
have a problem.

I habe tried:
Me.ChartSpace.SetData chDimCategories, chDataBound, "[Austritt_per by
month]"
This groups all (year, week, day, minute, second) in the dropzone. How
can i only add the year?

Thanks very much!
Regards
Lars
 
Top