Lockable aspect ratio in charts.
It would be handy to be able to lock the aspect ratio of a chart. I specifically use scatterplots to display a visualization of land surveying points as a check that data entry was correct. Because UTM coordinates are so large and the extent of the survey points changes with every entry the chart continually resizes.
When you say the “chart continuously resizes” are you referring to the chart’s value axis scale? The physical boundary of the chart should not resize when the data is added. When a chart is inserted, the default size is 3″×5″ which doesn’t automatically change but the user can manually change it through the Format ribbon or resizing the chart via its drag handles.
Friedrich Geyer commented
Until the implementation you can perhaps use this solution: http://www.excelution.at/punkt-xy-diagramm-unverzerrt/
Thanks for the clarification.
Sorry for the confusion. Yes the axis scales continually resize as data is added. Ideally, the major gridlines on the axis would be able to be set to a rectangle and hold that 1 to 1 aspect, essentially just changing the "zoom level" as data is added and removed.
I could see it working where if you go into the properties and set the minimum and maximum values for the axis, then you have a checkbox or whatever to hold the specified ratio.
Also, I really like that you are soliciting feedback like this. Came here from the AMA.