I have four categories across multiple series of data. Let's call them Red, Blue, Green, Yellow. I have a stacked chart showing the numbers of data points in each category. The chart has labels showing the value of each point, centred in each colour.
However, sometimes there is none of a particular colour. Let's say on this occasion I have Red = 10, Blue = 5, Green = 0, Yellow = 6. The chart shows red, blue and yellow but I get an extra label, showing 0 for Green and it appears on the border between blue and yellow.
I know I can take this label off manually, but the chart is refreshed every day, so tomorrow I might have green after all, but no red.
Is there an easy way to suppress the zeroes?
However, sometimes there is none of a particular colour. Let's say on this occasion I have Red = 10, Blue = 5, Green = 0, Yellow = 6. The chart shows red, blue and yellow but I get an extra label, showing 0 for Green and it appears on the border between blue and yellow.
I know I can take this label off manually, but the chart is refreshed every day, so tomorrow I might have green after all, but no red.
Is there an easy way to suppress the zeroes?
