Plot a scatter chart with categories on the left.

[HAF32]

I want to turn a scatter chart on its head. having the categories listed on
the left and values at the bottom.

How can I do this?

 

[Andy Pope]

Hi,

Here are a couple of explanations,

Stephen Bullen's FunChrt2 example.
http://www.oaltd.co.uk/DLCount/DLCount.asp?file=FunChrt2.zip

and Jon Peltier has an explanation.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

 

[HAF32]

Thanks Andy, that did the trick!

Hi,

Here are a couple of explanations,

Stephen Bullen's FunChrt2 example.
http://www.oaltd.co.uk/DLCount/DLCount.asp?file=FunChrt2.zip

and Jon Peltier has an explanation.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy