Swap the X and Y axes

[LAUR]

I have a line chart on which I need the categories to appear on the vertical
axis and the data to appear on the horizontal axis - how can I swap them? I
tried swapping the source data in the dialog box but that doesn't seem to
work, unless I am doing something wrong.

 

[HEK]

It looks like http://www.peltiertech.com/Excel/Charts/axes.html#VertCatAxis
may help you. It might be easier to define yr chart as XY chart - see same
site to find an X-Y swap solution.
GL,
H.