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
Bookmarks