Excel 2010 bar chart data labels
Posted on 2014-01-14
I have a fairly simple bar chart that is linked to a table of data. This data may be zero, a number greater than zero, or the cell may be blank because no data exists. I want to show the data labels in the bar chart when the cell value is zero or greater, and I don't want the data label to appear if the cell is blank.
This seems straightforward, but after a lot of searching I have yet to come up with a solution as to how to make this happen. If I could just suppress showing all zeros and blanks, it would be a piece of cake. But I can't figure out how to show labels for zeros, while treating blanks as no label. Using NA() won't work in blank cells because the chart will actually show that text as the label. Any ideas? I know there is a VBA solution here, but that seems rather inelegant, and this has to apply to quite a few charts. Also, I'm don't want to hide rows or columns. Thanks for your help!