You can only make this switch if you change a column chart to a bar chart.

But if you want a line chart that's rotated, you can fake it:

http://peltiertech.com/Excel/Charts/DotPlot.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Ronnie" wrote in message
...
Is there a way to change places of the category (x) axis and the value (y)
axis? If so, how? I am using Excel 2003.
--
Ronnie