Hello!
I can change dimension label in pivot table(with macro), but i didn't find solution to change the definition of a dimension.
How i can do it?
To change label i'm using code, like this:
set chart = ActiveDocument.GetSheetObject("CH47")
set p = chart.GetProperties
set dims = p.Dimensions(i)
dims.Title.v = "test"
chart.SetProperties p
Best Reagrds,
Anton Aleksandrov