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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,022
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,022
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,176,370
Messages
5,902,741
Members
434,990
Latest member
Peter Jeffrey Gale

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