You need to use VBA to do this, as described in this article:

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

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

DK-Mech wrote:

When presenting results via scatter charts it is often preferred to keep the
scales identical on both axis (i.e. a unit on each axis is equal to the same
number of pixels on screen). Is it possible to do that in Excel?