graphing ordered non-numeric value

[mkchu]

How does one graph an ordered but non-numeric value (e.g. Excellent, Very
Good, Good, Satisfactory, Fair, Poor, Failed) on the Y-axis and the date on
the x-axis?

 

[Stephen Bullen]

Hi Mkchu,

How does one graph an ordered but non-numeric value (e.g. Excellent, Very
Good, Good, Satisfactory, Fair, Poor, Failed) on the Y-axis and the date on
the x-axis?

Probably the easiest way is to give each of them a number (e.g. Failed = 0,
Excellent = 6) and plot those. Then format the Y axis to show markers but no
labels and use text boxes for the labels.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

 

[Jon Peltier]

Or use a dummy series with data labels to provide the axis labels:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______