Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I can't find where I can add vertiacal line to the column, like this:
That's because you can't. There's no such option for straight/pivot table objects. The best you can do is use a text object, resize it so it looks like a vertical line and place it on top of the table.
You can try this (I've never done this with a pivot table but it works for straight tables) -
Go to the View menu and choose Design Grid
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.
I have a simple solution though it is not exactly what you will have but very close.
You can create a expression in the defination part , fill =' '
and then in the backgroud color and text color use =black()
adjust the width of that epression in your straight table.
You should be able to have a line like that.
Hope that helps!