J Jon Peltier Mar 11, 2005 #2 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/ _______
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/ _______