'%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 Display Multi-Line Month and Year Labels on an Excel Chart Axis
Question details
The user wants to format the x-axis date labels on an Excel chart so that the month and year are displayed on separate lines (e.g., 'Apr' above '18') to save space and improve readability.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Creating or formatting an Excel chart where limited horizontal space makes standard date axis labels difficult to read or overlap.
- Observed behavior
- Chart x-axis date labels appear on a single line, causing horizontal clutter or forcing the chart to angle the text when space is restricted.
Ensure your chart's x-axis is currently using valid date values rather than plain text, and verify that you have access to modify the format of the chart axis or the source data cells.
Use a Custom Number Format with a Line Break
Apply a custom date format directly to the chart axis using a keyboard shortcut to force a line break between the month and year.
By utilizing the Ctrl+J shortcut inside the Custom Number Format dialogue, you can insert an invisible carriage return. This splits your date components onto multiple lines, keeping your chart tidy without changing the actual data values.
Right-click the x-axis (horizontal axis) of your chart and select 'Format Axis' from the context menu to open the formatting pane.
In the Format Axis pane, click on 'Axis Options' (the column chart icon), then scroll down and expand the 'Number' section.
Uncheck the 'Linked to source' box. This ensures that the custom format you create will apply directly to the chart axis without being overridden by the worksheet cell formats.
In the Category dropdown, select 'Custom'. In the Format Code text box, type 'mmm', then press Ctrl+J on your keyboard to insert a line break, and type 'yyyy' (or 'yy' for a two-digit year). Click the 'Add' button to apply the format to your axis.
Create and Format Professional Charts Easily with WPS Office
WPS Spreadsheet provides intuitive and powerful chart customization tools, allowing you to easily adjust axis labels, apply complex custom number formats, and create beautiful data visualizations with zero hassle.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open the file containing your data and the chart you want to modify.
- 2. Access Axis settings: Double-click the x-axis on your chart to instantly open the Format Axis panel on the right side of the screen.
- 3. Apply the custom format: Expand the Number section, select Custom, enter your code like 'mmm' followed by Ctrl+J and 'yy', then apply it to perfectly stack your month and year labels.
Frequently Asked Questions
Why did my chart axis labels suddenly revert to a single line?
If the 'Linked to source' option remains checked in the Format Axis pane, your chart will continuously pull the formatting from the worksheet cells. If the source cells are formatted as a single line, the chart will override your custom axis format. Always uncheck 'Linked to source' to lock your custom multi-line format on the chart.
Can I format the axis to display the day, month, and year on three separate lines?
Yes, you can extend the custom number format by using the line break shortcut multiple times. In the Format Code box, type 'dd', press Ctrl+J, type 'mmm', press Ctrl+J, and type 'yyyy'. This will stack the day, month, and year vertically.
Does the Ctrl+J shortcut work in Excel for Mac?
The Ctrl+J shortcut is specific to Windows. On Excel for Mac, you generally need to use 'Option+Command+Return' or 'Control+Option+Return' to successfully insert a line break inside a custom format text box.
