how do i label the axis?

[Guest]

how could i rename the numbers on the x-axis to become alphabets?
Originally it was 1,2,3 and 4. How can i change it to a, b, c and d?

 

[Guest]

You can do this one of two ways:

1) Have a, b, c,d in your X range and plot a LINE CHART (easy)
2) Follow the procedures in Jon Peltier's Vertical Category Axis example,
but apply to X axis (more difficult)

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

Regards,
Barb Reinhardt