Bar Chart Horizontal X axis placement

Barto

Board Regular
Joined
Jul 30, 2013
Messages
78
I have a bar graph that has text labels running down the y axis (down vertically). To get the text labels in the order I require on the Y axis I have had to do the following:
Format Axis > Axis Option > Ticked "Categories in reverse order"

By doing this I have the label flowing down the page in the correct order however I now have my X axis sitting horizontally across the top of the chart now instead of the bottom of the chart

how do I return it back to the bottom of the chart without changing the order of the labels on the y axis
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,275
Format Axis > Axis Option > Ticked "Value (Y) axis crosses as maximum category"
 

Watch MrExcel Video

Forum statistics

Threads
1,108,633
Messages
5,523,995
Members
409,555
Latest member
TIPSAREA

This Week's Hot Topics

Top