Plot Horizonal Bar Chart Left to Right for Negative Numbers

AboveBeyond

Board Regular
Joined
Aug 14, 2007
Messages
114
I have a horizonal bar chart with ONLY negative numbers and it's laid out from right to left. How to I lay it out so it starts from the LEFT to RIGHT. Thanks!

Current:
=========-1m
.....=======-500k
--========900k

Change to:
-1m========
-500k====
-900k======
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,817
Hi

Right-click on the horizontal axis, choose "Format Axis ..." and in the "Axis options" set "Values in reverse order"
 

Watch MrExcel Video

Forum statistics

Threads
1,108,507
Messages
5,523,310
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top