Excel | Reverse X and Y axis in chart

Solved
kTr -  
tontong Posted messages 2575 Registration date   Status Membre 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 réponses

ccm81 Posted messages 11033 Status Membre 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
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