Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this pie chart where the values on data points are overlapping with one another.
Say for example if the same happens in Bar Chart, we can change the orientation of label to Vertical or Horizontal based on the requirement. Unfortunately I can't find anything similar in Pie Chart.
Is there a hack to do this?
one better way is remove values on data points and display numbers in legend
Properties > Presentation > Legend > Show Numbers in Legend
Hi
PFA....
and one more way is also there to avoid this I.E using Other charts like Bar chart .i have shown you in attachment.
Kindly let me know ur status.
Regards,
Nagarjuna
Turn off values as pop up option in Presentation Tab:
Select the Values on Data Points option.
On the Sort tab, select the Y-Value option. Confirm Descending as the direction.
On the Presentation tab, deselect the Show Legend option.
Use dual function in expression:
lets say you want to sum sales i.e. Sum(Sales)
Dual(
Country & '-' &
Num(sum(Sales), '#,##0') &
Repeat(chr(13)&chr(10), rank(Sum(Sales))-3),
sum(Sales)
)
The ASCII characters 13 and 10 give us a carriage return and line feed. Note that there is a Rank()-3 here. Basically, the repeat doesn't kick in until you get to the fourth ranked value in the dimension. There is no reason to start staggering for the earlier values.