Home |
Search |
Today's Posts |
#1
|
|||
|
|||
plotting graphs
Is it possible to set the axes of a graph to be equally scaled?
|
#2
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plotting a single line graph | New Users to Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Graphs and sheet referencing? | Excel Worksheet Functions |