Pivot table grand total presentation

[#1]

Help. I

Help. I have a Pivot chart table.

How do you add lines above and below the Grand total cell.

thanks Sian

have a Pivot chart table.

How do you add lines above and below the Grand total cell.

thanks Sian

[Anonymous · Accepted solution]

Why do you want to add line after Grand Total.

Please elaborate your requirement  more.

Also if possible, post a sample app.

Regards

Nitin

[#3]

Hi Nitin.

Thanks for the reply. This is the table below as you can see the cost has a border in the grandtotal row and Number column doesn’t. I have no idea how I managed to do this and would like borders on both columns.

[#4]

Hi Sian,

Select Grid Design (ctrl-G) and Right Click on Chart ---> Custom Format Cell and Choose Cell Border.

Hope this helps.

Sridhar