Hiding Zero Results on Pie Chart

[Claire]

Good Day

Does anybody know how to hide zero results on a pie chart?

At the moment if one of my data values in a record is 0,
Access shows the data label and percent as 0 on the chart.
If all of my results are 0 for a record then all of the
labels and percentages are stacked on top of each other in
the empty chart.

Column charts do not show the 0 value, is there some way
to make the pie chart do the same thing?

Thanks everybody!

 

[Duane Hookom]

Change the Row Source property of the graph so that the record doesn't show
in its datasheet view.

 

[Guest]

Sorry for being so dense, but I'm not sure how to make the
value not show up in the datasheet view.

I have tried IIF but I keep getting an error.......

My Row Source from my pie graph is below

SELECT Null AS Expr1,
qryStaffMovementYear10Class.SumOfintTerminationStaff,
qryStaffMovementYear10Class.SumOfintRetireStaff,
qryStaffMovementYear10Class.SumOfintLeaveStaff,
qryStaffMovementYear10Class.SumOfintDisabilityStaff,
qryStaffMovementYear10Class.SumOfintIncreaseStaff FROM
qryStaffMovementYear10Class;

Thanks very much!!

 

[Duane Hookom]

I think you would have to go back a generation to the SQL of
qryStaffMovementYear10Class.

 

[Claire]

OK, I will check into that.

Thanks for the response Duane. I can not get to the
database until Monday unless I have time to recreate it.

Cheers,
Claire