Excel Tip: Freeze Chart Size from Cell Adjustments

As I mentioned in my MyExcelOnline podcast appearance, charting is one of the hardest Excel tools to master. My tip in the podcast showed how to add data with two keystrokes.

Sizing your graph can also be challenging, especially when you add or delete cells. Snap! Stretch! Your graph changes size with cell adjustments.

Follow these steps to avoid this common nuisance:

Download the exercise file here. 

How it works:

1. Double-click on perimeter of graph.
2. Select “Size & Properties” under “Format Shape”
3. Under “Properties,” select “Move but don’t size with cells.”

Like this tip? Subscribe for more and get your free ebook on “getting hired with Excel.”