How can I show Legend Total in Pie Chart

[#1]

Hello everyone,

How can I show the total in Legend area? Or I have to create another object to show the total.

Thanks in advance,

Deng

[erichshiino]

It does not go to the legend area, but you create a text label on the chart.

Go to chart properties -> presentation

Include an expression in 'Text in Chart'.

Go back to the chart, you should see your text somewhere.

Select the chart and Hold Ctrl+Shift to be able to move this label.

Regards,

Erich

[#3]

Thank you, Erich.

Can I add a number total after the label?

[erichshiino · Accepted solution]

Sure,

You can write an expression there like this:

='Total '& count( ID)

(you can replace count(ID) by any expression you want)

Rgds,

Erich

[prieper]

You simple have to add your formula or compose a textstring, like

='Total sales = ' & NUM(SUM(Sales), '#,##0$')

HTH

Peter

[#6]

Thank you Erich and Priper. I appreciate your help.