How do I change the y-axis on an Excel chart from numbers to words

[WDGILBERT]

I am plotting numbers which represent an activity for a machine. I would
like to substitute a description of the activity for the number on the chart.
Does anyone know how to do this?

 

[A little stuck]

I hope this answers your question:
1.Right click on the chart
2.Select 'Source Data'
3.Select the 'Series' tab
4.In 'Values', clear the box and select the list of words you want to appear
on the Y axis (have this list written somewhere on a worksheet)
5.Click ok

Was this what you were after?

 

[Jon Peltier]

This will plot everything as zero values, since they are all text.

You can fake it using one of these approaches:

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

- Jon

 

[Jon Peltier]

Which add-in? The Labeler? According to Rob's documentation, he has
modified the Labeler to allow it to be used by other VBA procedures. He
does not show how, unfortunately.

- Jon

 

[WDGILBERT]

I used the labeler. Maybe he will share this with us in th4 future.

 

[WDGILBERT]

For future reference, the information on how to use this in a macro is
included in the help for XY Chart Labeler. I tried it and it works. Thanks
for your help!