How to change total mode?

[#1]

Hi guys, 

I have created a chart and wanted to change the total mode, but the options of the total mode was grey out and I can't make any selection. Do you guys have any ideas how should I go about to solve this issue? Below is the print screen

Thank you.

[Anonymous · Accepted solution]

What chart type are you using,

In Pivot Chart you cannot set Total mode, instead use Partial sum in Presentation Tab.

If your chart type is Straight table then this total mode will be enabled

Regards

Nitin

[#3]

I am using pivot table. Thanks! that solve my problem.