#1   Report Post  
johnd
 
Posts: n/a
Default plotting graphs

Is it possible to set the axes of a graph to be equally scaled?
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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/
_______

johnd wrote:

Is it possible to set the axes of a graph to be equally scaled?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
plotting a single line graph plotting graphg New Users to Excel 0 February 26th 05 10:21 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze. Hatchet_Jack Charts and Charting in Excel 1 February 9th 05 10:31 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze. Bearclaw Chris Charts and Charting in Excel 0 February 9th 05 04:59 PM
Line Graphs and Bar Graphs Christopher Anderson Excel Discussion (Misc queries) 1 December 3rd 04 06:16 PM
Graphs and sheet referencing? Graham Excel Worksheet Functions 2 October 31st 04 11:37 PM


All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"