Pivot table column borders

[Anonymous]

Withing a pivot table, under custom format cells I can find a way to format the horizontal line before and after cells but not the vertical lines.

Does anyone know a way to do that for one column only?

Thanks

[m_woolf]

Make sure the Design Grid is turned on.

Then right-click the column and select Custom Format Cell

[Anonymous]

I can get that far but how do I format the vertical lines there is only the option to format the row lines

[trdandamudi]

In chart properties, take a look at the tab "Visual Cues" and see if that helps. Here you can select the column you want and you can set Bold, Italc or Underline.

Is this what you are looking for,,?

[Anonymous]

I am trying to format the border for the column so it appears like this:

 

[#6]

Hi Todd

I sugest you to change the background color of this column. Make a discret color change and you will get a similar efect (as I can see in your example). To do this (sorry me if you already know): right-click the table, choose Properties and in the Dimension (or Expression) tab, expand the [+] signal of the dimension (or expression) and change the BackgroundColor with RGB() function.

Let me know your decision, good luck!

Marcello

[trdandamudi]

Ok.. There is no option for Straight and Pivot table to format the columns.