Show two values in the Pie chart Legend

[amithmurali]

Hi guys,

In my pie chart. i want to show like this, both %contribution and actual value in the legend.

i am able to show either one at a time not both.

[kavita25]

I don't know about the numbers in legend..

but there is another option you can show contribution and revenue in bracket..

for e.g 23.34% (20.7)

OR

Check this workaround...

Hope it helps you

[Peter_Cammaert]

A few suggestions and workarounds:

Multiexpression in legend of Pie chart

How to show values beside legend in pie chart?

Peter

[jagan]

Hi,

It is not possible to display like this in Legend, but you can display on the pie chart by adding the expression like below

=Sum(Sales) & '(' &  (Num(Sum(Sales) /Sum(TOTAL Sales), '#.00%')) & ')'

and selecting Values on Data Points option for this expression.

Regards,

jagan.

[avinashelite]

Hi Amit,

As per my knowledge you cannot have legend with both the % and value  but you show it in different way in the Legend show the values and with the pie show the %.

This can be easily achieve by adding one more expression with the same calculation , i.e. one with the relative option checked and other with the un-check in this we you can achieve 

[#6]

Show a simple pie chart with a table alongside along it where one column is showing values and second column is showing relative %. Wouldn't it work?

[#7]

or why not show % in the pie and actual numbers in the legend? or even other way around?

[amithmurali]

the problem when i show both on the pie chart is that the size of the chart will become very small. i need a big piehcart and numbers in the legend

[jagan]

Hi Amith,

Check this file hope it helps you.  It is not at all possible to display in legend with you values.  Instead you can create Straight table beside this pie chart and display the same in that.

Reduce the number display by showing it is thousands, millions etc.

Hope this helps you.

Regards,

Jagan.