How to make vertical separator for colums in straight tabel?

[retko1985]

Hello,

somehow I did a separator, but now I forgot how

Can somebody remind me, how this is done?

Thank you.

[devarasu07]

Hi,

Try can try two ways,

method 1: simply adding empty column with background color as black

refer below is method 1 output.

Method 2: by using Design Grid - custom format border option.

Go to menu -->clik on View menu and choose Design Grid (or short to open grid mode press ctrl+G)

Then, on the chart you want to change, right-click on the number or a cell where you want to add a vertical line, from the menu that appears choose Custom Format Cell.

A Custom Format Cell window will appear that allows you to change cell borders and text attributes for individual cells or rows or columns. Make the change you want and click OK.

If that looks good then go back to the View menu and turn off Design Grid.

Thanks,

Deva

[asgardd2]

Hello!

To resize empty column you can use macro:

Sub changeSize
set chart = ActiveDocument.GetSheetObject("CH03")
set p = chart.GetProperties

set expr = p.Expressions.Item(1).Item(0).Data.ExpressionVisual

expr.ColWidth = 10 'size

chart.SetProperties p

end sub