invert axis and set origin

[hansaaa]

Hi, is it possible to "invert" the x or y-axis in a chart in excel?

I would like to have a line chart, where I have a point of origin (i.e. where the axes meet) at x = 0, y = 3, but then, from thereon, count "negatively", i.e. the next "higher" (in screen coordinates" y-line would be 2, then 1, etc. (up to 0, if possible, but I would still like the origin to be at x = 0, y = 3).

I have a little pic () of how I would like it:


chart.jpg


so, I guess, what I would like, is to (a), invert the y-axis, and then, (b), set a new coordinate origin at (0,3)

Thanks!

[MrShorty]

http://office.microsoft.com/en-us/ex...255.aspx?CTT=1 Look at the options to
1) set the "horizontal axis crosses at" input value and
2) "values in reverse order" checkbox

[hansaaa]

Aha! Together with setting "Label Position" to "High", that did the trick!

Thanks, Shorty!