How do I switch the display of axes?

[cjmpslz]

I would like the categorical info to be displayed vertically and the value
axis to be displayed horizontally. Is there any way around it?

 

[Bernard Liengme]

Only with a bar chart

 

[Dave Curtis]

Hi,

You can use a dummy axis, like Jon does on his site.

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

Dave

url:http://www.ureader.com/msg/10295879.aspx

 

[Jon Peltier]

This might be a better way to get the same effect:

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

- Jon