Hiding Zero Results on Pie Chart

  • Thread starter Thread starter Claire
  • Start date Start date
C

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!
 
Change the Row Source property of the graph so that the record doesn't show
in its datasheet view.
 
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!!
 
I think you would have to go back a generation to the SQL of
qryStaffMovementYear10Class.
 
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
 
Back
Top