Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
cmano
Creator
Creator

Pivot table adjust column

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.

Labels (2)
1 Reply
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:

marcus_sommer_0-1659713479892.png

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

- Marcus