Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I would like to inverse the bar graph in a way that the lower the number, the higher the bargraph should be.

Currently in the picture below, those items ranked 200 have the highest bar height while #1 ranked bars are almost invisible.

Is there a way to draw the graph as an inverse of ranking numbers?

enter image description here

share|improve this question
Consider a pie chart or stacked bar chart instead - it would give the ranking visually while retaining the data values – mindless.panda Mar 25 '10 at 20:27

4 Answers 4

up vote 3 down vote accepted

Screenshot and solution:

enter image description here

share|improve this answer
Man did I over-complicate the solution... Well done. The only change I would suggest is changing the 'Minimum' value to 1. – Sux2Lose Mar 26 '10 at 16:14
haha, finally! i got it! Thanks Adeel – Sung Mar 26 '10 at 21:50

You could just make a formula that says something like max number - current number to invert them manually, then plot that.

share|improve this answer
So far, I tried this but I cannot seem to change the Y-axis plot amount. I would like to show 1 on the top and 200 on the bottom on y-axis. Both Excel 2003/2007 doesn't have an option to modify the numbers... – Sung Mar 25 '10 at 20:19

Did you consider using inverse (1/x, relative size) or negative (-x, orientation) numbers to be plotted?

share|improve this answer
Yes, I have tried negation and inversion techniques but since I could not update the Y-axis value, it didn't work out even though inversion worked great. – Sung Mar 25 '10 at 23:16
The point is, that whatever Y value you need, this should by supplied by your function. You could perhaps post a manually created picture of the plot you want to display... – Lukas Mar 26 '10 at 7:38

The top-rated answer here worked for me... sort of. I was trying to do exactly the same thing as the questioner except on a chart of horizontal bars, not a chart of vertical columns. I should have been able to accomplish this by: - selecting "Format Axis" from the Y-axis - in the pop-up menu, selecting both "Categories in reverse order" and "Horizontal axis crosses: At maximum category"

But this only changed the order in which the data appeared -- it didn't "flip" the values as desires.

The workaround: Convert the chart to a vertical column chart, make the "Categories in reverse order" and "Crosses: at maximum category" selections in the Format Axis pop-up, then convert back to a horizontal bar chart.

Go figure.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.