Column Width in Pivot-Table

[#1]

Hi to all, it's me again....

today i have a problem with the column width in a Pivot Table. I will show you:

Country is the Dimension, all other columns are formulars. Here I have no problems with different column width.

But my aim is a Pivot Table like the next picture,

And here, all columns have the same width. I tried with a macro, but any changes will effect all columns.

sub CAdjust
set ch = ActiveDocument.GetSheetObject("CH16")
ch.SetPixWidth 0, 200
end sub

Does anyone know a solution for that problem?

best regards

Stefan

[TK_]

I have the exact same problem.

If you use a straight table instead, it will work, but if you also have users with the the ajax client then you can't use the straight table because it won't show up correctly in ajax..

I have tested this on my client (64bit) in QV v9 SR3 and SR4, and also the latest beta 10 version, but I get the same problem in all versions.

Hope someone can help us on this one.

cheers

Terje

[#3]

I don't think so that a "straight" table would work with my data.

Or is there a opportunity to display the dimension horizontal and the data vertical?

best regards Stefan.

[TK_ · Accepted solution]

I'm not sure if I understand you correctly, but mark your chart as a straight table instead of a pivot table and go to the Presentation tab. Here you can set the horizontal flag and the result is the dimension horizontal og expressions vertical.

But this won't work in the ajax client for some strange reason.

regards

Terje

[#5]

ok, that's quite easy.....

... but exactly what I was looking for. Sometime we're thinking too complicated...

Thousand Thanks,

best regards

Stefan