View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
 
Posts: 461
Default How do I change the y-axis on an Excel chart from numbers towords

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
Peltier Technical Services, Inc.
http://peltiertech.com/



A little stuck wrote:
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?