Order of series in barchart

karate718

Board Regular
Joined
Feb 25, 2005
Messages
93
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.

Code:
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%
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,019
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

Board Regular
Joined
Feb 25, 2005
Messages
93
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

Active Member
Joined
Aug 23, 2004
Messages
346
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

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,019
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

Board Regular
Joined
Feb 25, 2005
Messages
93
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.
 

Forum statistics

Threads
1,141,019
Messages
5,703,776
Members
421,315
Latest member
awaisnazir139

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top