Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi at all,
how can I set the legend within the chart like in this sample?
Thanks,
Martin
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
In the expression, write this:
Sum(Value)/Sum(TOTAL Value) & chr(10) & expression for select the colour
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.
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')
)
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