Hiding legend items that are zero

AuRedneckPrincess ✭✭✭
edited 09/19/22 in Smartsheet Basics

Good afternoon Sheeters!

I am developing a graph from a report where it tells me which department had what kind of injuries. when I try to chart it, i end up with an insanely long legend with colors doubled up because it's showing items that have 0. How do i chart with a legend and have the null items not show in the legend. so if there is a value, show it in the chart and the legend, and if there isn't then it doesn't show in the legend either.

I hope i haven't completely confused you!

the chart below shows what i' talking about. the tan colors are only for Unspecified Mechanisms in two departments however you can't tell if it's unspecified or long term exposure to sound (which is 0)

Best Answer