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!

 

[FMHasan]

Just Select Your Data, Insert a bar chart. Add data level. You will get solutions

 

[janema]

Just Select Your Data, Insert a bar chart. Add data level. You will get solutions

View attachment 85997

I did try "add data labels" but nothing will populate for the 0.00% amount. How did you get it to show???

 

[janema]

Just Select Your Data, Insert a bar chart. Add data level. You will get solutions

View attachment 85997

I see how you did that now, but if you do it that way, you cannot add a legend like on my image. I had to "switch row/column" in the data selection and course to get the legend and multiple colors to identify each performance rating. When you do it your way, the 0.00% data label just doesn't appear, so that just won't work

 

[FMHasan]

I see how you did that now, but if you do it that way, you cannot add a legend like on my image. I had to "switch row/column" in the data selection and course to get the legend and multiple colors to identify each performance rating. When you do it your way, the 0.00% data label just doesn't appear, so that just won't work

Is it okey?

 

[janema]

Is it okey?


View attachment 85998

Yes! Can you please share how you got it to show that way?

 

[FMHasan]

Yes! Can you please share how you got it to show that way?

I would be better share a video of this. Very easy way

 

[FMHasan]

Just Select Your Data, Insert a bar chart. Add data level. Select Bar & go fill option then select vary colors by point to get various automated colour of each bar .From chart elements unselect Axes & select Legend for bottom. That's all

 

[janema]

Just Select Your Data, Insert a bar chart. Add data level. Select Bar & go fill option then select vary colors by point to get various automated colour of each bar .From chart elements unselect Axes & select Legend for bottom. That's all

Unfortunately, I do not see an option to "add data level" - it isn't working for me Thanks for trying, but none of those steps seem to work on my end. I had to manually put it in for now.

 

[FMHasan]

Unfortunately, I do not see an option to "add data level" - it isn't working for me Thanks for trying, but none of those steps seem to work on my end. I had to manually put it in for now.

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