Legend in Chart

[Anonymous]

Hi at all,

how can I set the legend within the chart like in this sample?

Thanks,

Martin

[ecolomer]

In the expression, write this:

Sum(Value)/Sum(TOTAL Value) & chr(10) & expression for select the colour

[MK9885]

It will only show values (numerics), not text. But a hover over or show legend should work for you.

Check Show values on data points in Expression Tab and then check Show legend in Dimension Tab.

If a user hover over on that particular slice then it will show him/her the full name of the value and your num too.

[maxgro]

you can use dual in the expression (replace with your dim and expression)

dual(

Dim1 &' - '& chr(10) & Num(SUM(Expression1), '#,##0'),

Num(SUM(Expression1), '#,##0')

)

[kaushiknsolanki · Accepted solution]

Hi,

You can create another expression and make that as "Value on Data Points".

Lets assume you have

Dimension : Region

Expression : Sum(Sales)

Then create another Expression in Pie Chart where Expression will be

=Region&'-'& Num(Sum(Sales),'#,##0.00')

And click on this expression and Check the "Value on Data Points".

Hope this will help

Regards,

Kaushik Solanki