Creating PieChart with Sybase Database

[mann]

Hi all,
I m working on JFreeChart from couple of weeks.
I try to create the piechart with data coming from sybase database
this is the data:
Day: 2006-07-27 success: 117 partial:5 failed: 2
Day: 2006-07-28 success: 172 partial:0 failed: 5
Day: 2006-07-29 success: 96 partial:0 failed: 16
Day: 2006-07-30 success: 72 partial:0 failed: 16
Day: 2006-07-31 success: 0 partial:0 failed: 18
Day: 2006-08-01 success: 79 partial:1 failed: 29
Day: 2006-08-02 success: 97 partial:0 failed: 0

I have created the Piechart with 3 items i.e. success, partial and failed
but the entire chart get filled with just success data , partial and failed data is not getting shown ,just lable and legends are getting displyed.

Is thr any way to to work with plot or database so that i can show all three items clearly. I m using DefaultPieDataset for storing the data.
and PiePlot for rendering the chart

Please help for it

-Mann

[RichardWest]

You have 633 successes and 92 partials/fails. Partials and fails only represent 12.7% of the total. The partials alone represent 0.08% which would be hard to draw as one whole section let alone 7 sections. The fails should be more obvious, but each section would be less than 2% on average.

[mann]

Hi,
Thanks for your reply.
But is thr any way to overcome this problem and darw the pie chart

Please help

Thanks
Mann

[RichardWest]

But is thr any way to overcome this problem and darw the pie chart

Not really. The math is pretty inflexible. You could always try increasing the size of your pie chart to give each section more space, but you will need an incredibly large pie chart before the fails become obvious. Another option would be to create multiple pie charts; either one per day or one per outcome.