On Sun, 30 Mar 2008, in microsoft.public.excel.charting,
said:
I have been asked if it is possible to swap the x and y axis over on a
line chart. i can find info for doing this on a scatter but not on a
line chart. 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.

It's a missing chart type in Excel (note to Excel 2007 developers: this
might have been welcome, if you were going to "relaunch" charts, rather
than metallic effects). As you say, column charts are matched by bar
charts, and scatter charts are ambidextrous, but there's no way to have
a line chart on its side.

Google "Excel dot-plot" for ways to fake it. The first three hits on
Google should be Jon Peltier, Kelly O'Day, and Charley Kyd, all of whom
have different ways to achieve this.

The quickest way, of course, if you're printing or exporting to a slide,
is simply to format all the text sideways, then turn the resulting graph
by ninety degrees for display!

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.