Building a Pivot chart with VBA under Access

[Friedi]

I programm a pivot chart with an underlying table, where one of the fields 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.
No problem in placing fields in Filter and Value Axe.

The Catagory Chart Axe looks a bit crowded (all the production dates by
days), therefore I would like to programme that the field "Production Date"
is grouped into weeks on the Category Axe (showing the week numbers insteady
of all the dates)

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

Thanks