Bar Graph bars from opposite direction

[billw]

I am graphing a few numbers in a bar graph. Typically, the bottom of
the bar is "0", or the minimum value, and it goes UP to my data point.
I would like the bar to come from the maximum direction. I guess it
starts at Infinity, and goes 'down' to my data point.

I already know "Reverse Order" exists, but that justs flips the graph
upside down. (And the bars will start at 0 still)

I know I could do some tricks and work-arounds to meet my needs....but
just want to make sure there's not a quick way to do it.

example:
(bar graph of values "5", "7")

5
|
| 7
| |
| |
| |
10 ---------- <BOTTOM IS MAX VALUE...NOT MIN VALUE


thanks in advance

 

[Jon Peltier]

Bill -

I do this by accident all the time, so it was easy to recreate for my response.

Double click the vertical axis. On the scale tab, select Values in Reverse Order and
Category Axis Crosses at Maximum Value. Now the values go up from the bottom of the
chart (10 in your example) to the values (5 and 7).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[billw]

Thanks Jon!

Bill -

I do this by accident all the time, so it was easy to recreate for my response.

Double click the vertical axis. On the scale tab, select Values in Reverse Order and
Category Axis Crosses at Maximum Value. Now the values go up from the bottom of the
chart (10 in your example) to the values (5 and 7).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______