This one's better:

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

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


"Mike Middleton" wrote in message
...
http://www.peltiertech.com/Excel/Cha...egoryAxis.html



wrote in message
...
Hi

I have been asked if it is possible to swap the x and y axis over on a
line chart

i can find infor for doing this on a scatter but not on a line chart.

i have tried reformatting the data but this didn't work

i want the variable data values to be plotted on the horizontal axis
and the static values to be plotted on the vertical axis - i know i
can do this via a bar chart but this chart need to be a line chart

is this possible?

Ian