Excel Chart, Reverse X Axis direction with values
up vote
0
down vote
favorite
I currently have my chart set up like so :
How can I change the order so that it is read from left to right?
Right now it goes from recent date to last date. When I Reverse Categories, it also shifts the Y Axis to the right hand side, I want to keep the Y axis on the left.
microsoft-excel
add a comment |
up vote
0
down vote
favorite
I currently have my chart set up like so :
How can I change the order so that it is read from left to right?
Right now it goes from recent date to last date. When I Reverse Categories, it also shifts the Y Axis to the right hand side, I want to keep the Y axis on the left.
microsoft-excel
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I currently have my chart set up like so :
How can I change the order so that it is read from left to right?
Right now it goes from recent date to last date. When I Reverse Categories, it also shifts the Y Axis to the right hand side, I want to keep the Y axis on the left.
microsoft-excel
I currently have my chart set up like so :
How can I change the order so that it is read from left to right?
Right now it goes from recent date to last date. When I Reverse Categories, it also shifts the Y Axis to the right hand side, I want to keep the Y axis on the left.
microsoft-excel
microsoft-excel
edited Nov 13 at 16:06
Mureinik
2,19751525
2,19751525
asked Nov 13 at 15:27
excelguy
438
438
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You right click on the axis itself, and select format axis, or you can simply double click the axis depending on your version.
Then look for the setting categories in reverse order
, click this box.
See image below.
Thanks peter, This is what I want, however It also shifts the Y axis to the right, I want to keep the Y axis on the Left side.
– excelguy
Nov 13 at 15:53
I don't think there is an option to reverse the order AND keep the Y-axis on the left, apart from re-arranging your actual data set from which you plot the series
– PeterH
Nov 14 at 8:17
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You right click on the axis itself, and select format axis, or you can simply double click the axis depending on your version.
Then look for the setting categories in reverse order
, click this box.
See image below.
Thanks peter, This is what I want, however It also shifts the Y axis to the right, I want to keep the Y axis on the Left side.
– excelguy
Nov 13 at 15:53
I don't think there is an option to reverse the order AND keep the Y-axis on the left, apart from re-arranging your actual data set from which you plot the series
– PeterH
Nov 14 at 8:17
add a comment |
up vote
0
down vote
You right click on the axis itself, and select format axis, or you can simply double click the axis depending on your version.
Then look for the setting categories in reverse order
, click this box.
See image below.
Thanks peter, This is what I want, however It also shifts the Y axis to the right, I want to keep the Y axis on the Left side.
– excelguy
Nov 13 at 15:53
I don't think there is an option to reverse the order AND keep the Y-axis on the left, apart from re-arranging your actual data set from which you plot the series
– PeterH
Nov 14 at 8:17
add a comment |
up vote
0
down vote
up vote
0
down vote
You right click on the axis itself, and select format axis, or you can simply double click the axis depending on your version.
Then look for the setting categories in reverse order
, click this box.
See image below.
You right click on the axis itself, and select format axis, or you can simply double click the axis depending on your version.
Then look for the setting categories in reverse order
, click this box.
See image below.
answered Nov 13 at 15:30
PeterH
3,09832245
3,09832245
Thanks peter, This is what I want, however It also shifts the Y axis to the right, I want to keep the Y axis on the Left side.
– excelguy
Nov 13 at 15:53
I don't think there is an option to reverse the order AND keep the Y-axis on the left, apart from re-arranging your actual data set from which you plot the series
– PeterH
Nov 14 at 8:17
add a comment |
Thanks peter, This is what I want, however It also shifts the Y axis to the right, I want to keep the Y axis on the Left side.
– excelguy
Nov 13 at 15:53
I don't think there is an option to reverse the order AND keep the Y-axis on the left, apart from re-arranging your actual data set from which you plot the series
– PeterH
Nov 14 at 8:17
Thanks peter, This is what I want, however It also shifts the Y axis to the right, I want to keep the Y axis on the Left side.
– excelguy
Nov 13 at 15:53
Thanks peter, This is what I want, however It also shifts the Y axis to the right, I want to keep the Y axis on the Left side.
– excelguy
Nov 13 at 15:53
I don't think there is an option to reverse the order AND keep the Y-axis on the left, apart from re-arranging your actual data set from which you plot the series
– PeterH
Nov 14 at 8:17
I don't think there is an option to reverse the order AND keep the Y-axis on the left, apart from re-arranging your actual data set from which you plot the series
– PeterH
Nov 14 at 8:17
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375060%2fexcel-chart-reverse-x-axis-direction-with-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown