

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pie Chart not showing values properly?
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Stagger labels working for me..
Try Once...
Dual(
Num(SUM(Expression), '#,##0') &
Repeat(chr(13)&chr(10), rank(SUM(Expression))-2),
SUM(Expression)
)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you will get some help from below thread


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have a look...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Conditionally hide the small values (click + next to the expression and enter a condition under show values.
- Use Dimension Limits to group the small value into 'Others'.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks all for your value suggestions
Staggering labels not working in this, may be my dimension have 5 values only.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Stagger labels working for me..
Try Once...
Dual(
Num(SUM(Expression), '#,##0') &
Repeat(chr(13)&chr(10), rank(SUM(Expression))-2),
SUM(Expression)
)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Raju..
its working now as expected.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
