interchangine catergory and values axis

[Guest]

How do I flip the catergory and value axis around so that the X axis becomes
the catergory axis and the Y axis is the value axis?
thanks
100gree

 

[Frank Kabel]

Hi
see:
http://www.peltiertech.com/Excel/Charts/axes.html#SwitchXY

 

[Jon Peltier]

Or http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html, depending on how you
interpret the question.

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