View original (French)

[EXCEL] 3-Axis Chart

Kev -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor 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.

1 answer

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    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)
    0