My bar chart is to skinny and I have dipslayed values of zeros

1) It will depend on exactly why your bars are too thin.
If your bars are too thin because you have several "blank" categories, you will need to do something to the data to hide or remove the blank categories from the chart's data. If your data are arranged in a filterable list, filtering the data might be the easiest way to deal with extra categories.

You can try adjusting the gap width (https://support.office.com/en-us/art...mchangespacing ), but this will not have much effect if the problem is extra categories.

2) Exactly what do you need to do to "suppress" the zeros? Do you need to remove those categories from the chart, or simply have no bar/data labels at that category? If you just need to suppress the appearance of a data label, then I would use a number format that hides zeroes. If you need to remove the category completely, you will need to do something in the spreadsheet to hide/remove the zero categories from the data in the spreadsheet.
You might review this essay that talks about dealing "gaps" in data: http://peltiertech.com/mind-the-gap-...g-empty-cells/

In the graph I've used Data Labels Outside End and because my data have many zeros it makes the chart ugly. Removing the zeros would improve the layout.

Did you try applying the same number format that you used in the cells to the chart data labels?

I cannot replicate that. I am surprised that the chart data labels treats the number format differently than the spreadsheet cells. Are these 0 values exactly 0, or are they small non-zero numbers that only look like 0?

A sample file uploaded to the forum would be helpful. Click "Go advanced" below the quick reply box, then click manage attachments to bring up the file uploader.