Swapping X and Y Axis - line Chart

[ian.tiesdell]

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

 

[Del Cotter]

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!

 

[Mike Middleton]

http://www.peltiertech.com/Excel/Charts/Y_CategoryAxis.html

 

[Jon Peltier]

This one's better:

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

- Jon