使X轴和Y轴刻度在Excel图表上相等 [英] Make the X and Y axis scales equal on an Excel chart

问题描述

我希望我的Excel图表的X轴和Y轴在屏幕上具有相同的比例，因为我在绘制地理数据。 1公里乘1公里的广场应该看起来像一个正方形，不像一个矩形，即地图在一个或另一个方向上没有挤压。在Matlab中，这样做的命令是 axis equal 。

I'd like the X and Y axes of my Excel charts to have the same scale on the screen, because I'm plotting geographical data. A 1km by 1km square should look like a square, not like a rectangle, i.e. no squishing of the map in one or the other direction. In Matlab, the command that would do this is axis equal.

如何使用VBA？

我可以直接在Excel中查看更简单的解决方案吗？

Am I overlooking an even simpler solution directly in Excel?

推荐答案

除了guitarthrower的答案，你需要做以下事情：
选择图表的绘图区，然后手动设置绘图区的高度和宽度。

In addition to guitarthrower's answer you will need to do the following: Select the 'Plot Area' of the chart and then manually set the height and width of the plot area.

Sheets("Chart1").PlotArea.Select
  Selection.Height = 500
  Selection.Width = 500

只要设置轴的最小值和最大值，图表就会被压扁。

Just setting the axis min and max values will still allow the chart to be 'squished'.

这篇关于使X轴和Y轴刻度在Excel图表上相等的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！