Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Given the following data and chart:

chart

Why is the chart displayed from right to left and how do I change it to appear from left to right?

share|improve this question
up vote 3 down vote accepted

Go to the Layout tab under Chart Options > Axes > Horizontal Axis > More options:

enter image description here

Then in the dialog, uncheck Values in reverse order:

enter image description here

(I initially had it the correct way round before checking this option)

share|improve this answer
1  
Is this 2013? This is how mine looks like: i.imgur.com/6s9kmVb.png – Eran Apr 3 '14 at 18:42
1  
@Eran I have excel 2010. See if you can find Horizontal Axis options somewhere? Maybe when you right click on the horizontal axis? – Jerry Apr 3 '14 at 18:45
1  
@Eran I can also access this dialog by right-clicking on the horizontal axis > Format Axis – Jerry Apr 3 '14 at 19:03
1  
@Eran Hmm, I just looked over the docs and it's apparently under axis options. Could you try looking there? – Jerry Apr 3 '14 at 19:11
1  
@Eran Spotted! i.stack.imgur.com/kslLo.png – Jerry Apr 4 '14 at 11:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .