graphs

How can I make a graph have the same scale on both axis?I'm using it as a plotter, and so I want it to come out with a scale map...

It's imperfect, and requires a bit of tweaking, but this web page should
help:

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

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


"grandfilth" <[email protected]> wrote
in message news:[email protected]...
>
> How can I make a graph have the same scale on both axis?I'm using it as
> a plotter, and so I want it to come out with a scale map...
>
>
> --
> grandfilth
> ------------------------------------------------------------------------
> grandfilth's Profile:
> http://www.excelforum.com/member.php...o&userid=28240
> View this thread: http://www.excelforum.com/showthread...hreadid=486648
>

can this be used dynamically? I've been trying it but cant work out how to use it...
i would like it to work when u change the input data without having to press anything else...

It's not a dynamic solution. You would need to hook it into a
Worksheet_Change event procedure to make it appear dynamic. Chip Pearson has
a page or two on Excel events:

http://cpearson.com

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


"grandfilth" <[email protected]> wrote
in message news:[email protected]...
>
> can this be used dynamically? I've been trying it but cant work out how
> to use it...
> i would like it to work when u change the input data without having to
> press anything else...
>
>
> --
> grandfilth