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

  • Thread starter Thread starter WDGILBERT
  • Start date Start date
W

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?
 
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?
 
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
 
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!
 
Back
Top