Horizontal Bar Chart Axis Question

[nataliek92]

I have a simple bar chart in excel 2010. Sorry I can't post a picture of the chart at the moment. The data included in my chart comes from the below table :
[TABLE="width: 500"]
<tbody>[TR]
[TD]Supplied Data Levels
[/TD]
[TD]Forename
[/TD]
[TD]Surname
[/TD]
[TD]D.O.B
[/TD]
[TD]House Num
[/TD]
[TD]Postcode
[/TD]
[TD]Valid Phone Number
[/TD]
[/TR]
[TR]
[TD]Benchmark
[/TD]
[TD]0%
[/TD]
[TD]100%
[/TD]
[TD]0%
[/TD]
[TD]100%
[/TD]
[TD]100%
[/TD]
[TD]55%
[/TD]
[/TR]
[TR]
[TD]Today
[/TD]
[TD]0%
[/TD]
[TD]100%
[/TD]
[TD]0%
[/TD]
[TD]100%
[/TD]
[TD]100%
[/TD]
[TD]62%
[/TD]
[/TR]
</tbody>[/TABLE]

My vertical axis shows the categories (forename, surname, etc) and my horizontal (x) axis shows the % levels. The use of a horizontal bar chart is just personal choice as I think it looks better in my report.

I would like the categories on the y axis to be in the order as above, from top to bottom. i.e. "Forename" at the top to "Valid Phone Number" at the bottom. It's quite annoying that excel places them from bottom to top. Anyway, I know how to do this, by choosing Axes -> Vertical axis -> Show right to left axis.

But this then puts my x axis at the top of the chart! Is there any way I can move it to the bottom?

Help!

 

[pgc01]

Hi Natalie

Try this:

Right-click on the Y axis->Format Axis...->Axis Options, click on the "Categories in Reverse Order" checkbox.

 

[Jon Peltier]

1. In a horizontal bar chart in Excel, the vertical axis is the X axis, and the horizontal axis is the Y axis. The rationale is that the X axis is always the independent axis, and it's vertical in this chart type.

2. Format the vertical axis (double click on it) and where it says "Horizontal Axis Crosses", choose "At Maximum Category".