View original (French)

Excel | Reverse X and Y axis in chart

Solved
kTr -  
tontong Posted messages 2575 Registration date   Status Member Last intervention   -
Hello,
.
I would like to create a graph with curves in Excel, but by reversing the axes. That is to say, I want the curves in my graph to go from top to bottom instead of from left to right.
.
Here is an image that summarizes my problem (or the result that I want)
.
http://imageshack.us/photo/my-images/708/sanstitreplk.png/
.
Thank you in advance.
.
PS: I still haven't understood how to create line breaks on this forum ^^

Configuration: Windows 7 / Chrome 24.0.1312.57

5 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello
    • right-click on the vertical axis
    • Axis Format/Scale
    • check Values in reverse order


    And if you also want to swap the X and Y axes
    • Source Data/Series and change the ranges of the two series


    Have a good continuation
    16
    1. kTr
       
      Thank you for your response.
      .
      However, when I do this, my X-axis ends up at the top. It looks something like this:
      .
      .
      ----Info1----Info2---Info3----Info4
      1
      2
      3
      4
      5
      .
      .
      And the direction of the curves remains unchanged :/
      0