Order of series in barchart

[karate718]

Hi,

I have the below table. However, when I create a bar chart, the values are displayed in descending order. In other words, Value 10 is on top, followed by value 9, all the way down to 1. Can I get the graph to put Value 1 at the top?

Thanks.

Value 1	-1.40%
Value 2	0.10%
Value 3	-5.00%
Value 4	-2.70%
Value 5	0.70%
Value 6	1.10%
Value 7	-3.80%
Value 8	0
Value 9	6.10%
Value 10	-1.10%

 

[Greg Truby]

Right click the axis in question. There is a checkbox for "plot in reverse order". Sorry not more specific as to the exact location of the checkbox but I'm working from memory at the moment, my Excel is running a lengthy macro.

 

[karate718]

Greg,

Thanks, this is exactly what I wanted to do. However, it now moved the hoirzontal axis labels to the top of the chart. Is there a way to put those back down at the bottom?

Thanks.

 

[SidBord]

Try this:
Right click on the X axis (horiz) and select "Format Axis".
Select the "Patterns" tab at the top.
Under "Tick Mark Labels", select "Next to Axis"

Hope that works for you.
SId

 

[Greg Truby]

Underneath the Values in reverse order checkbox, there is a Category (X) axis crosses at maximum value checkbox. Try checking that -- does that flip it back south for you?

 

[karate718]

I actually clicked on the y axis, selected Category (Y) axis crosses at maximum value, and it moved the horizontal labels back down to the bottom.

Freg and SId, thanks for your help.