I would like to see a Graph in X-Y. This was available in 123 for.
 

In Lotus 123 I had the possibilty to have an actual X-Y graph which always
kept its the relation between the 2 axes.
In excel I use the spreaded graph but I always have to change the dimension.
I use it to draw 2 dimensional figures in the spreadsheet.

Not sure I understand what you want to do but you might want to check
out the XY Scatter chart (as opposed to the Line chart).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
In Lotus 123 I had the possibilty to have an actual X-Y graph which always
kept its the relation between the 2 axes.
In excel I use the spreaded graph but I always have to change the dimension.
I use it to draw 2 dimensional figures in the spreadsheet.

You can use VBA procedures to modify the axes in ways that are not built
into Excel. To make the gridlines equally spaced in the X and Y
directions, try this:

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

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

RCordewener wrote:

In Lotus 123 I had the possibilty to have an actual X-Y graph which always
kept its the relation between the 2 axes.
In excel I use the spreaded graph but I always have to change the dimension.
I use it to draw 2 dimensional figures in the spreadsheet.

This code makes the axes 1:1 on the monitor (which was much more than I could
do), but when I printed it out, Excel still flattened the graph. Is there a
way to make Excel print a graph with axes scaled 1:1? Other than trial and
error?

"Jon Peltier" wrote:

You can use VBA procedures to modify the axes in ways that are not built
into Excel. To make the gridlines equally spaced in the X and Y
directions, try this:

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

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

RCordewener wrote:

In Lotus 123 I had the possibilty to have an actual X-Y graph which always
kept its the relation between the 2 axes.
In excel I use the spreaded graph but I always have to change the dimension.
I use it to draw 2 dimensional figures in the spreadsheet.

Select the chart, then select File | Page Setup... | Chart tab. Select
the 'Custom' size option. I *believe* that will retain the shape of the
chart.

Alternatively, select the cells beneath the chart and print them at 100%
scaling.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article , =?Utf-
8?B?S2FyZW4gR2lic29u?= <Karen says...
This code makes the axes 1:1 on the monitor (which was much more than I could
do), but when I printed it out, Excel still flattened the graph. Is there a
way to make Excel print a graph with axes scaled 1:1? Other than trial and
error?

"Jon Peltier" wrote:

You can use VBA procedures to modify the axes in ways that are not built
into Excel. To make the gridlines equally spaced in the X and Y
directions, try this:

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

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

RCordewener wrote:

In Lotus 123 I had the possibilty to have an actual X-Y graph which always
kept its the relation between the 2 axes.
In excel I use the spreaded graph but I always have to change the dimension.
I use it to draw 2 dimensional figures in the spreadsheet.

This still results in a slight flattening, so it will take one trial to determine
how much to fudge it by.

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

Tushar Mehta wrote:

Select the chart, then select File | Page Setup... | Chart tab. Select
the 'Custom' size option. I *believe* that will retain the shape of the
chart.

Alternatively, select the cells beneath the chart and print them at 100%
scaling.