frame around a pivot table

[#1]

hello all,

i hope somebody can help me.

i just made the attached pivot diagramm (see attachment)

i am searching for the QV function to get a frame around the dimension "month" like in the attached picture shown.

i will be thankful for any help.

so long

marti

[#2]

To do custom formatting, enable designer grid (CTRL+G). Now if you right click the table you can see an option "Custom Format Cell". You can get custom borders/shading etc here, which is selfexplanatory.

Kiran.

[#3]

as I hit the CTRL+G the designer grid did appear,

but I didn't find the "custom format cell" option.

[#4]

CTRL+G is to toggle designer grid. Once its active you can see grid on the sheets.

I can get this and I use QV 10 SR3. But make sure you right click on the pivot table.

Kiran.