Forum Discussion
Locking the aspect ratio of a chart
PReagan Thanks. I understand aspect ratio. Perhaps I should have phrased the question differently. I need a square grid. Let's say that I remove the gridlines. Then the "grid" is the entire chart area. I make it 5" x 5" and check "Lock aspect ratio." But if I drag one of the handles on the side, the aspect ratio changes and the grid becomes non-square. If I drag a corner handle, the size changes but the aspect ratio is held fixed. I have a feeling this is only possible by locking the chart on a protected sheet.
perkin_warbeck I think that "locking ratio of chart" simply means that dragging one of its four corners will change the chart's size but not its aspect ratio. Unfortunately this constraint does not accompany the drag process for any of the four sides of the chart.