ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do i label the axis? (https://www.excelbanter.com/charts-charting-excel/20670-how-do-i-label-axis.html)

jiji

how do i label the axis?
 
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?

Barb R.

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?



All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com