[[email protected]]

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]

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.

[Mike Middleton]

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

[Jon Peltier]

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