Using Excel 2013 with this example table:

bar value
one 25
two 75
three 25
four 135
five 120
six 155

I'm trying to make a bar graph but I have to choose a maximum bound lower than the highest value in the table. In this case the maximum bound is 150 and it seems like bar six is 150 when in fact it is 155. This is shown in the diagram.

excel.jpg

I want to label any bar that exceeds the maximum bound. In this case, I would like Excel to automatically place text above bar six that shows it is 155 rather than 150. Is this possible?

threshold.xlsx