Whole number are not displayed on x-axis

Hi,

I want to show whole number on Value Axis(x-axis).Some time values in the sheet may be 1 not less than 0.How i should force chart to show only whole numbers.

Pls find the attachment of my excel sheet.

Thanks,

Arun

Currently you can only set the data labels as a whole. Maybe you can try to clear those 0% in source data.