ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   plotting graphs (https://www.excelbanter.com/charts-charting-excel/17080-plotting-graphs.html)

johnd

plotting graphs
 
Is it possible to set the axes of a graph to be equally scaled?

Jon Peltier

You can format the axes (if it's a scatter chart) so the X and Y have
the same min and max values.

If you want equal values to be equally spaced on the two axes, it's not
so easy. You need to resort to a VBA solution like this:

http://peltiertech.com/Excel/Charts/SquareGrid.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

johnd wrote:

Is it possible to set the axes of a graph to be equally scaled?



All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com