Pivot table adjust column

[cmano]

Hello there.

For reference i have a pivot table with 2 columns.

I use a edit module the below macro :

sub x

set chart = ActiveDocument.GetSheetObject("CH82")

chart.SetPixWidth 0,200
chart.SetPixWidth 0,900

end sub

The problem is that it takes only the wider width and adjust the other...

Any suggestion?

Thank you for your time.

[marcus_sommer]

I'm not sure if it's supported respectively documented to adjust the column-width individually with a macro. The best would be to play with the various pix options listed within the APIGuide.qvw and also mixing/extending the provided examples:

Important to note: a individual width is only for different expressions possible and not to a solo expression with n horizontal dimension-values.

- Marcus