Programming Pivot charts with VBA under Acccess

[Friedi]

I programm a pivot chart with an underlying table, where one field is called
"Production Date". This field gives all the production dates (by days).
This field "Production Date" is placed in the Pivot Chart in the Category
Axe.
Till there no problem, every thing is fine; but the chart axe looks a bit
crowded (all the production dates by days), therefore I would like to
programme that the Category Axe field "Production Date" is grouped into weeks.

Manually is it easy to do , but I would like to programm it.
Can anybody give an input?

Thanks

 

[JuneTheSecond]

One idea might be to use a function that records your operation into macro.