Bar of Pie shows slivers for 0 values?

[Otawata]

Hi All,

I'm creating a Bar of Pie chart from a data table. In a typical bar or pie chart, I don't see anything represented in the chart area for "0" values. However, in the bar of pie chart, it is showing a small bar piece for my "0" values and I can't figure out how to not have this displayed in the chart. I don't want my users to get confused that there is some amount. In the example below, the dark yellow value at the bottom is "0", but shows up in the bar. Can you help? Thank you!

 

[vletm]

Otawata​

What is Chart data range?
Can You send a sample Excel-file?

 

[p45cal]

I suspect that those chart elements have borders:


Select the element and if they have a border you'll see something like:



It could be automatic or solid border.
Try changing it to No line:



then deselecting the chart element:



There may still be little something on mine in the pic above!

You should be able to remove the borders from the whole series rather than one point at a time (you can).
If this isn't the problem, then a file demonstrating your problem would be in order, then we can have an explore.

 

[Otawata]

OMG, they do have borders. I don't usually add them, but this time I did to make the squares in the legend look a bit more robust. I didn't expect the borders to show on 0 values, but that did the trick. Thank you so much!