Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i trying to create Pie chart, some values are not showing properly can any one suggest how to show properly
please see below pie chart for your reference
.
Thanks in advance
Rajesh
Stagger labels working for me..
Try Once...
Dual(
Num(SUM(Expression), '#,##0') &
Repeat(chr(13)&chr(10), rank(SUM(Expression))-2),
SUM(Expression)
)
you will get some help from below thread
The values are showing properly but its overlapping , if you observe all the values at the lower range are overlapping because they don't have the space to show the complete values properly ...other two values have good space and hence the numbers are visible . Better hide the value on data points and show only in the legend
Hope this helps you .
Have a look...
If exact values need to be visualised, you are better off using a bar chart than a pie.
You usually do not need much detail for the 'rats and mice" , so you could:
Thanks all for your value suggestions
Staggering labels not working in this, may be my dimension have 5 values only.
Stagger labels working for me..
Try Once...
Dual(
Num(SUM(Expression), '#,##0') &
Repeat(chr(13)&chr(10), rank(SUM(Expression))-2),
SUM(Expression)
)
Thank you Raju..
its working now as expected.
U can try Staggering labels but if u really want to show values instead of percentages better go for bar-chart. Pie charts are meant to show percentages.