[Excel] Orthogonal Coordinate System
Solved
albus
-
fjyf -
fjyf -
Hello,
I am looking to plot a scatter plot in Excel within a Cartesian coordinate system.
The question has already been asked and has not been resolved.
What is a Cartesian coordinate system?
If I'm not mistaken, and that's what I'm looking for, it consists of two orthogonal axes, both with units equal to "1". The unit is "1" on both axes.
I double-clicked on the axes of my charts. The scales are identical. Yet on the screen, the graduations appear different.
Does the solution involve making a square chart? Because that works.
The problem is that I want a nice chart, not a squashed square chart.
I am looking to plot a scatter plot in Excel within a Cartesian coordinate system.
The question has already been asked and has not been resolved.
What is a Cartesian coordinate system?
If I'm not mistaken, and that's what I'm looking for, it consists of two orthogonal axes, both with units equal to "1". The unit is "1" on both axes.
I double-clicked on the axes of my charts. The scales are identical. Yet on the screen, the graduations appear different.
Does the solution involve making a square chart? Because that works.
The problem is that I want a nice chart, not a squashed square chart.
2 answers
-
Hello Albus,
Your chart has the dimensions you give it, since you can move the sides with the mouse. And in any case, it should fit on your screen.
Excel adjusts the scales of the axes so that the ranges of the series (x and y axes) are compatible with the available space. The axis, in most cases, is orthogonal, but it cannot be orthonormal.
If your x-axis goes from 0 to 10, and your y-axis from 0 to 100, you can always distort your chart to maintain these proportions and orthonormalize your axes. But good luck with readability…