How to show the totals and subtotals in different colors

[#1]

Hi,

I need to set the clors for subtotals and totals in the pivot chart.How do i do that.

Please help.

Thanks in advance.

[Anonymous]

Try turning on the design grid then right clicking the table....you will see the option "Custoemr Format Cell"....you can then change the format of the individual cells.

Cheers.
Ad.

[#3]

Thank you