[EXCEL] 3-Axis Chart
Kev
-
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58548 Registration date Status Contributeur Last intervention -
Hello,
As part of a training, I need to create a 3-axis chart; here is a photo
http://hpics.li/2b8d3b2
I made it by hand, is there a method to create it in Excel?
We managed to create a 2-axis chart, but we couldn't find anything for 3 axes.
Best regards.
As part of a training, I need to create a 3-axis chart; here is a photo
http://hpics.li/2b8d3b2
I made it by hand, is there a method to create it in Excel?
We managed to create a 2-axis chart, but we couldn't find anything for 3 axes.
Best regards.
1 réponse
Hello.
Sorry, but I don't understand anything from your graph!
First of all, what is the purpose of the first axis on the left, which has no graduations?
And the P axis in the middle, also ungraduated, is it Pweight or Price?
The right axis still has no graduation...
What do the 9 oblique lines represent?
The information in the right part of the image is incomprehensible to us who, in CCM, did not attend your training and do not know what you want to represent...
In any case, be aware that Excel does not allow such a structure for a graph with a moveable axis: There is always a horizontal axis (abscissa) and a vertical axis (ordinate); if there is a second vertical axis (called a secondary axis), it is completely to the right of the graph.
--
Retirement is great! Especially in the West Indies... :-)
Raymond (INSA, AFPA, CF/R)
Sorry, but I don't understand anything from your graph!
First of all, what is the purpose of the first axis on the left, which has no graduations?
And the P axis in the middle, also ungraduated, is it Pweight or Price?
The right axis still has no graduation...
What do the 9 oblique lines represent?
The information in the right part of the image is incomprehensible to us who, in CCM, did not attend your training and do not know what you want to represent...
In any case, be aware that Excel does not allow such a structure for a graph with a moveable axis: There is always a horizontal axis (abscissa) and a vertical axis (ordinate); if there is a second vertical axis (called a secondary axis), it is completely to the right of the graph.
--
Retirement is great! Especially in the West Indies... :-)
Raymond (INSA, AFPA, CF/R)