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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
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/
_______
 
Back
Top