y axis category labels on line graph
 

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

y axis category labels on line graph
 

Try one of these:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Elaine" wrote in message
...
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

y axis category labels on line graph
 

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" wrote:

Try one of these:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Elaine" wrote in message
...
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

y axis category labels on line graph
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Elaine" wrote in message
...
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" wrote:

Try one of these:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Elaine" wrote in message
...
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