Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I change a dimension label via macro?
Nevermind, I found.
set chart = ActiveDocument.GetSheetObject("CHC01")
chart.AddDimension dimSelection.Item(0).text
set p = chart.GetProperties
set dims = p.Dimensions
dims(0).Title.v = dimLabel.Item(0).Text
Nevermind, I found.
set chart = ActiveDocument.GetSheetObject("CHC01")
chart.AddDimension dimSelection.Item(0).text
set p = chart.GetProperties
set dims = p.Dimensions
dims(0).Title.v = dimLabel.Item(0).Text