Represents a chart axis title.
![](/uploads/1/2/7/1/127152327/769819074.png)
-->
Remarks
After you create a chart, you can add axis titles to the horizontal and vertical axes in charts that have axes. You can't add them to charts that don't have axes such. Please see the steps below to add the Axis titles: Step 1: If you work with Excel 2016 or after, you can use the element handle. Click on the chart and you will see 3 icons appear on the right of the chart; Step 2: Click on the plus sign, you will see the list of the 'Chart Elements' such as Axis, Axis Titles, Chart Title, etc.
Use the AxisTitle property of the Axis object to return an AxisTitle object.
The AxisTitle object doesn't exist and cannot be used unless the HasTitle property for the axis is True.
Example
The following example activates embedded chart one, sets the value axis title text, sets the font to Bookman 10 point, and formats the word millions as italic.
Methods
Properties
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Often there is a need to change the data labels in your Excel 2016 graph. The procedure is a little different from the previous versions of Excel 2016. You will add corresponding data in the same table to create the label. You can also create a new set of data to populate the labels. Be more efficent and accomplish more with Excel Beginner to Advance Course up to 90% discount from this link.
1. Select the Chart that you have created and navigate to the Axis you want to change.
2. Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Edit
3. The Edit Series window will open up, then you can select a series of data that you would like to change.
4. Click Ok
![How to add axis labels in excel 2018 How to add axis labels in excel 2018](/uploads/1/2/7/1/127152327/198964155.png)
For a time series like months, when you click select data you will not have the option to directly edit the x-axis. However, you still can by simply clicking Edit Legend Series and choosing X values. However, if you graph is chronological or time series based you need to pick a complementary chronological data. For categorical data, you don’t need to worry about this. Also, you can directly change x values from Select Data Source window. But essentially the steps are the same.
Follow the visuals instructions below or watch the video:
Follow the visuals instructions below or watch the video:
Create a graph. From the image below, you can see that this graph is based on the index column and the Selected Period column. Our goal is to replace the X axis with data from Date Column.
Right-click the graph to options to format the graph. In the options window, navigate to Select Data to change the label axis data.
Once you choose Select Data, an Edit Series window will open with information on the axis.
Our goal is to change the x-axis so that you can delete the x values and replace them with the new values. If you have chronological data, you can directly access the labels.
Our goal is to change the x-axis so that you can delete the x values and replace them with the new values. If you have chronological data, you can directly access the labels.
Once, you add the new data and click OK, you will be able to see the update labels reflecting the new data.
![](/uploads/1/2/7/1/127152327/769819074.png)