You can see the horizontal axis labels on the right side of the box. Under “Horizontal (Category) Axis Labels”, select Edit. Right-click on the chart and click on Select Data. You will see a menu listing several options. You can also change the text of the axis without modifying your source data: The same changes can be observed in the chart when we correct the typo “Q11” to “Q1”.Ĭhanging the source data will automatically reflect on the graph.The data in the “Quantity” column is represented on the x-axis By changing the data in the cell, you will be able to change the text on the axis. For our example, we can observe a typo in the D4 cell, which must be changed from Q11 to Q1. For example, in the image below, “Quantity” is represented on the x-axis. Then, change the source data of the corresponding axis you want to change.First, decide which axis labels you want to change (e.g., the x or y-axis).

So, if you wish to change the text of the axes: Method 1: Changing the source dataĪfter making a graph based on your data, you will see that the axes automatically show text present in the source data. There are two main ways to change what a label says on your Excel graph.

Change the format or appearance of axis labels.In most of these, data represented on the axes have labels to help viewers understand the meaning of each axis. For example, if you have data for stock prices where the smallest difference between dates is seven days, Excel sets the base unit to days, but you can change the base unit to months or years if you want to see the performance of the stock over a longer period of time.Excel has several different types of graphs and charts to choose from. You can also manually change a category axis to a date axis.Ī date axis displays dates in chronological order at specific intervals or base units, such as the number of days, months, or years, even if the dates on the worksheet are not in sequential order or in the same base units.īy default, Excel determines the base units for the date axis based on the smallest difference between any two dates in the worksheet data. When you create a chart from worksheet data that uses dates, and the dates are plotted along the horizontal (category) axis in the chart, Excel automatically changes the category axis to a date (time-scale) axis.

Change excel graph axis label