Chart Dress Up

[gz3s36]

I have a bar graph. The bar always stops short of the top of the chart no matter what the highest value is. Is there a way to make your highest value go to the very top of the chart?

[Kaper]

You have to format your vertical axis to use manually inserted (not automatically calculated) max value.

[gz3s36]

How do I do that?

[Kaper]

Easy way:
Right click on one of numbers on vert axis and from pop-up select formatting axis then for max write your constant value.
Long way: select chart, then from ribbon for charts layout, close to upperleft corner locate dropdown list of chart elements, select there vertical axis and immediately below - format.