Hey Andy, you're a genius. Thanks man. It works wonderfully, both in Excel
2003 and 2007. I would never have guessed that by myself, since the name
"category" doesn't really mean much to me when referring to the AXES.
The more I navigate through different programs (not only Microsoft's),
including Adobe Illustrator, the more I notice the non-functionality of some
newer features. For example in Adobe Illustrator the ROTATION tool is a whole
new redefinition of Euclidian geometry. If I want to rotate my object 90
degrees clockwise (right angle in XY plane), it rotates it in a mirror (it's
rotated 180 degrees in the Z-axis). So I still haven't figured out their
geometry. Thus, making a simple plot it takes days instead of minutes. Enough
complaints. Thanks Andy. Cheers.
"Andy Pope" wrote:
Hi,
Double click the category axis (Y) and on the scale tab check the option,
Categories in reverse order. This will both place the value axis (X) at the
top and make the first category appear at the top.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Unhappy" wrote in message
...
All Excel versions I know are very good at making bar charts (I mean those
charts in which the bars are horizontal). But the problem is that the
X-axis
is at the bottom, and items for the Y-axis are placed in reverse order as
desirable (for example, first item in the series is placed at the bottom
-close to the X-axis, last item in the series is placed first from the top
-far from the X-axis). I don't know if I'm making myself clear, posting a
picture would be more easier but it's impossible. Anyway, my question: Is
there any way to:
1-Place the X-axis at the top.
2- Avoid Excel to invert the order of items (ideal order would be: first
item at the top, last item at the bottom).
Thanks.