9 Replies Latest reply: Sep 16, 2015 6:39 AM by bhaskar deevi RSS

    Pivot table column width problem


      I have a pivot table where expressions are rows and dimensions are columns (see the attached demo for illustration).

      Is there a way to resize the first column (expression labels) without resizing dimension columns at the same time?


      As seen you can see from the attached document there is a lot of wasted space if columns can't be resized separately.


      I tried the following macro but it will resize all the columns including the first label column.


      sub resize
       set chart = ActiveDocument.GetSheetObject("CH02")
        chart.SetPixWidth 1,100
       end sub


      Switching dimensions back to rows is not an option.