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

    Pivot table column width problem

      Hi,

      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.