[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 réponses
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…
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…
I found a little macro on the internet that allows you to do it
http://xcell05.free.fr/telecharge/index.html
I do this because orthonormal bases have mathematical properties regarding the scalar product (scalar product = normu * normv * cosinus(u,v))
the link for the macro doesn't work. Does anyone know another one?