chart slices not properly displaying

Hi,
check out attached chart picture.
As per the data, the chart in my report suppose to show 11 slices.
But in final report view it hows only 4 slices.

It seems some slices has been overlapped.

Any suggestions to format chart so that chart will show all expected slices.

Thanks.

Find more posts tagged with

Comments

mwilliams

Hi mh10,

What version of BIRT are you using? Also, what are the values of the 11 slices so I can recreate this?

mh10

Hi Michael, 
I am using BIRT 2.2.2. And below are the values i want to show on pie chart (more than 11 as i mentioned previously) 
 
TOTAL_UNITS 
 
368413.61736 
713746.524 
680643.5256 
642310.76 
4019470.311 
28865.716 
174847.632267 
1008 
1019759.477506 
353156.666667 
963969.26174757 
50671.829203883 
317143.76 
6943.233333333 
145260.333333333 
817899.388 
876830.414239467 
247133.0776699 
101795.744 
795031 
708731.53773097 
558977.812 
555457.67378641 
240448.862240003 
354298 
550393.746666333 
131722.62135922 
9675 
64515.3333333 
4630557853 
3814.16 
1810429551.56995 
21995956107.3347 
1319748.888 
52666 
131433.52103563 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Hi mh10, 
 
What version of BIRT are you using? Also, what are the values of the 11 slices so I can recreate this?</blockquote>

mwilliams

mh10,

The reason this is happening is because the very large numbers dwarf the other values so much that their slice is too small to show. All of these values are right next to each other, so because there's no spacing for the slices, there is none for the names either. The best way to handle this will be to lump the small values into one slice, then add another pie chart that shows how that slice is broken up.

mh10

can you explain me how to lump together these small values into one slice and then adding another pie chart which will show details of that slice? 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">mh10, 
 
The reason this is happening is because the very large numbers dwarf the other values so much that their slice is too small to show. All of these values are right next to each other, so because there's no spacing for the slices, there is none for the names either. The best way to handle this will be to lump the small values into one slice, then add another pie chart that shows how that slice is broken up.</blockquote>

mwilliams

mh10,

For the numbers you gave me, your chart is only going to be able to show 4 slices. Really only 3 slices because the 33 values that don't show up only add up to just over 17 million, so the slice isn't really visible. The next lowest number is almost 2 billion. You can group the smaller values into 1, so they don't overlap though, by setting the minimum slice in the "category series" section of the format chart tab in the chart editor to 1,000,000,000.

Then, you can create another chart and add a filter in the chart editor on the select data tab to only allow the values under 1,000,000,000. This still looks kinda sloppy because of the large range of values you still have left, but it's better than all the numbers overlapping in one spot. Let me know if you have any other questions.

mh10

Hi Michael, 
1) I set the minimum slice in the "category series" section of the format chart tab in the chart editor to 1,000,000,000. But, 
Check out the attached chart image, it is showing one slice with value 17,006,783.428 (which is lower than 1,000,000,000)....why? 
 
2) can we change the slice color as we want? How? 
 
3) Below the chart, I am looking to display legend names along with related integer/ percentage value. How? 
 
4) can we give the name to each slice as we want, now chart displays values as per Data provided form databse. 
Also, How to give one common name to group of slices on pie chart? 
 
 
Thanks 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">mh10, 
 
For the numbers you gave me, your chart is only going to be able to show 4 slices. Really only 3 slices because the 33 values that don't show up only add up to just over 17 million, so the slice isn't really visible. The next lowest number is almost 2 billion. You can group the smaller values into 1, so they don't overlap though, by setting the minimum slice in the "category series" section of the format chart tab in the chart editor to 1,000,000,000. 
 
Then, you can create another chart and add a filter in the chart editor on the select data tab to only allow the values under 1,000,000,000. This still looks kinda sloppy because of the large range of values you still have left, but it's better than all the numbers overlapping in one spot. Let me know if you have any other questions.</blockquote>

melinda

Hi Michael,
I seem to have a similar problem as mh10, but the values that I'm working with are names (not numbers).

As an example Jane Ann Johnson ate 6 apples. There are 500 apples allocated to each person. Using this example, I have 100 people and I'm trying to show how many apples each person ate.

I want to display each person's name next to a bar that spans somewhere between 0 - 500.

Right now, I'm using a bar chart, but I have too many names, one associated with each bar, that unless I expand my page size to 17X17, I only see half of the names. Sometimes I'll get a bar (with a number) to display, but no name next to it.

Suggestions?

Thanks!
Melinda

mwilliams

Hi Melinda,

Without the area being big enough to display the info you're wanting to display, you won't be able to display all the names in a standard view. Here are a couple ideas:

You could remove the labels or make the text very small and do tooltips in the mouse over event.

You could create a separate report with just the chart in the larger size that if the user clicked on the small chart, they could see the expanded chart with all the names.