How to Make Horizontal Stacked Bar Chart Labels Display Horizontally in Excel
Question details
The user needs to force category labels on a horizontal stacked bar chart to display horizontally rather than vertically.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Formatting a horizontal stacked bar chart where long category text defaults to an unreadable vertical orientation.
- Observed behavior
- Excel automatically rotates long category labels vertically on the axis, making them difficult to read on a horizontal stacked bar chart.
Ensure your chart's source data contains the separate columns you wish to combine for your labels, and insert a new blank column next to them to serve as your helper column.
Use a Helper Column and Adjust Axis Text Direction
This method gives you complete control over category labels by combining your data into a single string and forcing the axis to display it at a 0-degree angle.
By creating a helper column, you can concatenate text from multiple columns into one clean label. This unified text can then be mapped to your chart's axis and forced into a horizontal layout using the axis formatting properties.
Insert a new column next to your source data. Enter a formula to join the text from your category columns, for example: =A2&" - "&B2, and drag the fill handle down to apply the formula to the entire column.
Right-click your stacked bar chart and select 'Select Data'. Under the Horizontal (Category) Axis Labels section, click 'Edit' and select the cells in your newly created helper column.
Right-click the category axis directly on your chart and choose 'Format Axis' from the context menu to open the formatting pane.
In the Format Axis pane, navigate to 'Size & Properties' (the icon with a square and size arrows). Under 'Text direction' or 'Custom angle', set the rotation to 0 degrees to ensure the labels display horizontally.
Create and Format Bar Charts Easily with WPS Spreadsheet
WPS Spreadsheet provides intuitive chart formatting tools, allowing you to seamlessly customize axis labels, utilize helper columns, and adjust text angles with no hassle.
- 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the data for the stacked bar chart.
- 2. Set up the helper column: Type your concatenation formula in an empty column to merge multiple cells into unified horizontal labels.
- 3. Customize chart axis: Double-click the chart axis to open the properties panel on the right, select 'Size & Properties', and set the custom angle to 0 degrees.
Frequently Asked Questions
Why does Excel rotate my bar chart labels vertically?
Excel automatically rotates category labels vertically or diagonally when the text is too long to fit horizontally within the available axis space. This automatic behavior prevents text from overlapping.
Can I wrap text on a chart axis instead of rotating it?
Yes, you can often force text wrapping by inserting a line break character in your helper column. Use the CHAR(10) function in your formula (e.g., =A2&CHAR(10)&B2) to split long labels into two lines, making them fit horizontally.
Will the helper column update automatically if my original data changes?
Yes. Since the helper column uses a dynamic cell reference formula, any modifications you make to the original columns will immediately update in the helper column and reflect on the chart.
How do I hide the helper column without breaking the chart?
If you hide the helper column, the chart will hide the labels by default. To fix this, right-click the chart, choose 'Select Data', click 'Hidden and Empty Cells', and check the box for 'Show data in hidden rows and columns'.
