Excel - Y Axis 'letters'?

[CindyA]

Is there a way to put 'letters' on the Y-Axis instead of numbers. I have a list of names with corresponding a, b, c, d, etc., and would like the Y-axis to reflect which letter corresponds to the person. Is this possible?

Thanks in advance and have a nice day.

 

[RalphA]

Hmm, sounds as if a table would do the trick for you. Will it?

 

[CindyA]

Table in Excel?

Not sure what you mean by this when you say 'table'. The only 'table' feature I know of is in Word. Please explain ... or is my brain just not working yet this morning?

 

[RalphA]

Imagine a spreadsheet such as this:
In cell A1, enter Name: In cell B1, enter Letter
In cell A2, enter Adam : In cell B2, enter a
In cell A3, enter Buck : In cell B2, enter b
In cell A4, enter Jack : In cell B2, enter c
and so on. This, to me, looks like a table.

But, the question is, would this be suitable for your purposes?

 

[tusharm]

You can simulate the effect with a dummy series. Jon Peltier has an example on his site. You will have to search for it at www.peltiertech.com

Is there a way to put 'letters' on the Y-Axis instead of numbers. I have a list of names with corresponding a, b, c, d, etc., and would like the Y-axis to reflect which letter corresponds to the person. Is this possible?

Thanks in advance and have a nice day.

 

[CindyA]

Thanks

Looks like this will work. Thanks much.