Thread: How do I change the y-axis on an Excel chart from numbers to words
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
A little stuck[_2_] A little stuck[_2_] is offline
external usenet poster
  
Posts: 21
Default How do I change the y-axis on an Excel chart from numbers to words
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?

"WDGILBERT" wrote:

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?
Reply With QuoteReply With Quote