Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to avoid overlapping of values in pie chart
Follow these steps to create a pie chart with staggered labels:
1. Create a new pie chart.
2. Add your dimension.
3. On the Expressions tab, add the following expression:
Dual(
Dimension & '-' &
Num(Measure, '#,##0') &
Repeat(chr(13)&chr(10), rank(Measure)-6),
Measure
)
4. Select the Values on Data Points option.
5. On the Sort tab, select the Y-Value option. Confirm Descending as
the direction.
6. On the Presentation tab, deselect the Show Legend option
If u are facing this issue.we have one more way too.
GOTO >> Properties>Enable Show Numbers in Legend.
If you are not reaching your requirement.
Share sample file ?
Follow these steps to create a pie chart with staggered labels:
1. Create a new pie chart.
2. Add your dimension.
3. On the Expressions tab, add the following expression:
Dual(
Dimension & '-' &
Num(Measure, '#,##0') &
Repeat(chr(13)&chr(10), rank(Measure)-6),
Measure
)
4. Select the Values on Data Points option.
5. On the Sort tab, select the Y-Value option. Confirm Descending as
the direction.
6. On the Presentation tab, deselect the Show Legend option
good to hear it worked for u
Hi there
My Expression:
Dual(
Ded_Description & '-' &
Num(sum(EFT_Volume), '#,##0') &
Repeat(chr(13)&chr(10), rank(sum(EFT_Volume))-6),
sum(EFT_Volume)
)
My Graph
Please assist