So I have a file that values different properties with a scale of 1-5 in increments of 0.25. The issue I am having is that when I apply data labels to the bar graph, the labels show zero. I can of course manually delete these zeros out, but would rather find a way to systematically do this as it will save me the hassle to do so in the future. Attached is the file for reference. Right now my zeros are filtered by a custom filter to appear as " - ". Thanks for any help in filtering out data labels that show as zero or " -"
For simplicity Look at Cell G 22
and G36
G36 chart is what I want end result to filter to from G22 chart. Thanks for any insights.
Bookmarks