Manipulating Charts in Excel

[janema]

Does anyone know how to get a 0.00 value to show on a bar chart? See image below. There are a data element, "Needs Improvement" that is a 0%, but I want it to still show on this chart and I just can't figure out how. I tried formatting the axis and other things, but not luck.

This is the source data of the chart if that helps. Thank you!

 

[janema]

Select a bar & click right button of mouse. then you will find add data level option

I tried that and the field list view too, but not working for me unfortunately. There is no "add data level" option.

 

[FMHasan]

I tried that and the field list view too, but not working for me unfortunately. There is no "add data level" option.

You can use this file

New Microsoft Excel Worksheet.xlsx
	H
27
Sheet1