'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Change Horizontal Axis Labels in Excel for Mac
Question details
The user needs to change or edit the horizontal axis labels in an Excel chart on a Mac but finds they cannot be edited directly within the chart.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Editing chart elements to display correct category names on the horizontal axis.
- Observed behavior
- The horizontal axis labels cannot be edited directly by clicking or typing on them in the chart.
Ensure that the new labels you want to use for your horizontal axis are already typed into a continuous range of cells in your worksheet.
Update Axis Labels Using the Select Data Feature
The most effective way to change axis labels in Excel for Mac is by modifying the chart's data source to point to the correct worksheet cells.
In Excel, chart labels are dynamically linked to your spreadsheet data. To change what appears on the axis, you must update the source reference rather than trying to type over the chart text directly.
Click anywhere on your existing Excel chart to activate it and reveal the chart-specific menu options.
Navigate to the 'Chart Design' tab that appears in the top ribbon menu once the chart is selected.
Click on the 'Select Data' button to open the data source dialog box.
In the 'Horizontal (Category) Axis Labels' field, click the selection icon and highlight the worksheet range containing the new labels you want to display, then click 'OK'.
Easily Create and Edit Charts in WPS Spreadsheet
WPS Office provides a highly intuitive and free alternative to Excel for Mac. You can effortlessly manage chart data, customize axis labels, and create stunning visual reports with full compatibility.
- 1. Open your Workbook: Launch WPS Spreadsheet and open your existing Excel file.
- 2. Select the Chart: Click on the chart you wish to modify to bring up the Chart Tools.
- 3. Edit Data: Click 'Select Data' in the ribbon menu.
- 4. Update Category Labels: Under the Category Axis Labels section, select the new cell range containing your labels and confirm.
Frequently Asked Questions
Why can't I double-click the horizontal axis to change the text?
In Excel, horizontal (category) axis labels are dynamically linked to worksheet cells. You cannot type text directly into the chart axis; you must change the source data or select a different cell range.
How do I change dates on the horizontal axis in Excel for Mac?
To change date formats, right-click the horizontal axis, select 'Format Axis', and go to the 'Number' section. If you need different dates entirely, update the source cells or use 'Select Data' to choose a new range.
Can I type my own labels into the Select Data dialog instead of selecting cells?
Yes, you can manually enter labels by typing them as a comma-separated list enclosed in curly brackets (e.g., {"Jan","Feb","Mar"}) directly into the Horizontal Axis Labels range box, though using worksheet cells is generally easier to manage.
