This trick is so simple and also an incredible time-saver if you want to build beautiful worksheets or dashboards where charts and data live happily together.
Begin selecting the chart you want to align.
The dots surrounding the chart allow you to resize the chart as you please.
Simply click and hold on one of these dots with left mouse button, then press the Alt key while you drag the dot.
This will snap the dot to a grid line, if you are not happy with the location simply drag the dot to the line you want to align.
Repeat above step with the remaining three chart corner dots.
Remember that if you resize columns or rows the chart will follow and resize automatically.