Odd behavior - CR 10 chart / legend

[lmctech]

Using Crystal 10.0.0.533 and reporting off of an Excel sheet for the datasource (I know, I know....)

I have a chart that looks great, and the user is pleased with the output but I see weirdness that I dont like.

Symptoms:
Data records found = 8
Chart display shows = 8
Chart has 6 slices (pie chart) - but the 8 records are all in 4 of the slices, the other two slices dont appear.
BUT - all 6 show on the legend, as if it's thinking that there are records that *should* be in the 7th and 8th pie chart.

Why would a grouping show in a legend and not on a report graphic?

 

[lbass]

Try using chart options to show the value of each pie slice. It might be that slice is too small to display. (I couldn't follow the logic of their being 8 records and only 6 slices, with 8 in 4 slices, etc.)

-LB

 

[lmctech]

The value of the slice is 0.0 - it doesnt show on the pie, and it doesnt show in the recordset at all (checked the raw data!) but the darn legend seems to want to insist it be there.

 

[lbass]

I wonder if it is some negligible amount that like .0005 or something. Maybe try rounding the value and see if it still appears.

-LB