Chart - Legend

[questionnaire response database question]

I have created a pie chart that have gender VS count of gender. However,
whenever the pie chart has the first value as null (e.g., total # of female
is 0), the legend "Slice 1" appears. Is there anyways that I can eliminate
the "Slice 1" legend even the value is null?

I have tried to delete "that" legend, which is the blue one. Is would work
if the first value of is not null. However, if the first value is not null,
no lengend will be shown.

 

[Al Camp]

I think I would try filtering those Null values out in the query behind the
Chart with an.
Is Not Null
criteria for that value.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"questionnaire response database question"

 

[questionnaire response database question]

Thanks!!! it works!!!!!!!!!! you are awesome

I think I would try filtering those Null values out in the query behind the
Chart with an.
Is Not Null
criteria for that value.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"questionnaire response database question"