Add a Secondary Axis to a Chart in Excel | CustomGuide To link an axis title to an existing cell, select the title, click in the formula bar, type an “= (13)…ĥ. The Chart Options toolbar (12)…Ĭlick an axis title and begin typing to write a label by hand. When creating a chart in Excel, you may want to add a axis labels to your chart so the users can undertand the information contained in the chart. How to add horizontal axis labels in Excel 2016/2013 How to Add Axis Labels in Microsoft Excel – Ĭlick anywhere on the chart you want to add axis labels to. #1 select a chart and click the chart that you want to add axis title in your worksheet.
In the Axis label range enter the cell references for the x-axis (7)… In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit.
How can I make an Excel chart refer to column or row headings?
