Change of Y- into X-axis

[Jan Hass]

Hi,

Can someone please give me directions how to exchange y-axis and x-axis
in a line graph (value and category axis)?

Thanks

Jan

 

[Jon Peltier]

Jan -

By definition, Excel only allows the category axis to be the horizontal
axis in a Line chart. You could create a Scatter chart and switch the X
and Y, using some dummy values for the vertical values, and then use a
dummy series to provide labels on the vertical axis. Here's some
instructions from my web site:

http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#VertCatAxis

- Jon

 

[Jan Hass]

Jan -

By definition, Excel only allows the category axis to be the
horizontal axis in a Line chart. You could create a Scatter chart and
switch the X and Y, using some dummy values for the vertical values,
and then use a dummy series to provide labels on the vertical axis.
Here's some instructions from my web site:

http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#VertCatAxis

- Jon

Jon,

Thank's a lot! It's a great site and it did the trick.

Jan