y axis category labels on line graph

[Guest]

Hi,

I need to specifiy the y axis and the x axis labels, I can get the x-axis
labels on by using a line graph in excel, however the y xais only appears as
numbers.

Any suggestions? I have got the xy chart labeler but I can't seem to get it
to do this.

Many thanks,
Elaine

 

[Jon Peltier]

Try one of these:

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

- Jon

 

[Guest]

Thanks for your help, but I really need to label both the y and the x axis
category, I have not been able to do that using the links below.

I will have another try though.

 

[Jon Peltier]

There is no way to plot categories on a Y axis. Excel cannot plot text, only
numbers. The examples I cited show how to use Excel to plot numbers, while
putting labels on the chart so people interpret the vertical axis as having
categories.

- Jon