graphing ordered non-numeric value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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