Hide null column values in chart legend

[Alex]

Is there a way to hide null column values in a chart legend? I still need
them returned in the query because I need the values to show as zero in my
chart, but I don't want to see the <> identifier in the chart legend. Thank
you.

 

[Alex]

I just wrote an Iif statement to assign null column heading, "no data".
Thank you.