jiayouluckystar from YouTube asks about controlling the word wrap of long labels along the x-axis. While the chart format dialog offers no control over word wrap, it can be done.
Transcript of the video:
You'd like to win an entry to the Model off World financial modeling competition?
Go to paper.exceldailynews.com.
Subscribe, the next day when you get your email I'll show you how to enter.
Learn Excel from MrExcel podcast episode 1797: Chart X-Axis Labels Word Wrap.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in from YouTube talking about the X-axis labels here.
They don't want a word wrap.
And I see that you actually have very little control over the word wrap.
If we'd come here and choose the X-axis labels and double-click, and back here on the alignment tab, there really is no word wrap option.
You know, there are no good choices that I can find in the chart.
So, I have two solutions.
Solution number one changes the chart type to a bar chart.
With bar charts, you get a lot more room for product names to stretch out.
So that's the standard.
One CTRL+Z will undo that.
If you do want to have control though, all we have to do is go back to the cells - the cells that contain these values, and you can have control.
So, we'll say Guerilla Data Analysis, and where you want the words to wrap, do 'ALT+Enter'.
And this was actually already an abbreviation using, ALT+Enter, Microsoft Excel.
So I've created a cell that's going to be three rows high.
And you see that the X-axis label respects that.
So this was really Pivot Table, ALT+Enter Data, ALT+Enter Crunching, Excel Outside the Box.
Let's do Excel ALT-Enter, Outside the ALT-Enter box and Don't Fear ALT+Enter The ALT+Enter Spreadsheet.
Like that.
And so, by changing the word wrap in the cells using ALT+Enter, you get control.
And then, that will change the word wrap along the X-axis down here.
So, you would think there'd be some sort of a setting in the format dialog for the chart?
It's not there, but instead just go back and force the word wrap in the cells and then in a word wrap down here in the X-axis.
Well, hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Go to paper.exceldailynews.com.
Subscribe, the next day when you get your email I'll show you how to enter.
Learn Excel from MrExcel podcast episode 1797: Chart X-Axis Labels Word Wrap.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in from YouTube talking about the X-axis labels here.
They don't want a word wrap.
And I see that you actually have very little control over the word wrap.
If we'd come here and choose the X-axis labels and double-click, and back here on the alignment tab, there really is no word wrap option.
You know, there are no good choices that I can find in the chart.
So, I have two solutions.
Solution number one changes the chart type to a bar chart.
With bar charts, you get a lot more room for product names to stretch out.
So that's the standard.
One CTRL+Z will undo that.
If you do want to have control though, all we have to do is go back to the cells - the cells that contain these values, and you can have control.
So, we'll say Guerilla Data Analysis, and where you want the words to wrap, do 'ALT+Enter'.
And this was actually already an abbreviation using, ALT+Enter, Microsoft Excel.
So I've created a cell that's going to be three rows high.
And you see that the X-axis label respects that.
So this was really Pivot Table, ALT+Enter Data, ALT+Enter Crunching, Excel Outside the Box.
Let's do Excel ALT-Enter, Outside the ALT-Enter box and Don't Fear ALT+Enter The ALT+Enter Spreadsheet.
Like that.
And so, by changing the word wrap in the cells using ALT+Enter, you get control.
And then, that will change the word wrap along the X-axis down here.
So, you would think there'd be some sort of a setting in the format dialog for the chart?
It's not there, but instead just go back and force the word wrap in the cells and then in a word wrap down here in the X-axis.
Well, hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
