View Single Post
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

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/Cha...egoryAxis.html

Regards,
Barb Reinhardt

"jiji" wrote:

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?