Formatting Issue

[#1]

Hi

I am having a formatting issue in pivot.

In the attached JPEG file,

Number of Engaged telephonic Coached Members & Percentage of Engaged telephonic Coached Members  are expressions and month is the dimension.

If you see in the Attached Jpeg,Expression labels are large whereas the data eg 1 for Jan is small but the foramtting is not correct.

I want the data to be fit with the column without toouchng the expression labels.

[CELAMBARASAN]

Hi,

This is not possible here.

Because you have pivoted the dimensions to X axis and Expressions to Y axis.

Column width for the expression values always based on the expressions width.

[er_mohit]

right click on chart and fit coloumn to data  if it doent succeed your required issue then put a cursor on expression line where is jan on top row then you 'll see the cross type sign when you put your cursor on the line then double click on it hope it helps

or you can try the macro code for this  create a button and add action

sub x

set chart = ActiveDocument.GetSheetObject("CH02") // here put object id of pivot

chart.SetPixWidth 0,100

chart.SetPixWidth 1,100

chart.SetPixWidth 2, 0

end sub

after that click on button