Today's question: how do you change the font size in a chart legend in Excel. There are a lot of settings for the legend, but none appear to let you change the font size. The answer is hidden in plain sight.
Transcript of the video:
Learn Excel From MrExcel, Podcast Episode 1794: Chart Legend Font Size.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Today's question is sent in from YouTube, how to change the chart font size in the legend, and I understand that this is going to seem daunting.
I'm going to click the legend and press CONTROL+1.
Especially in Excel 2013, where they have all these different icons here, my general rule is you always start with the chart icon because that's where the important things are, but not for the legend, and you can click through all of these, open all of these, and you're not going to find anything that lets you change the font size.
You would think it would be here under TEXT OPTIONS, the TEXT FILL, no, the TEXT OUTLINE.
There's all of these.
None of these have font size.
Even the TEXT BOX, no font size there, right?
So, you know, it's frustrating that they give us all these different choices over here in the dialog box and none of them let us change the font size, but it is really, really easy when you get right down to it.
Just click on the legend.
Come back to the HOME tab.
In the HOME tab, we have the INCREASE FONT SIZE, DECREASE FONT SIZE.
All of these icons here will work on that text box.
So, to increase the font size, just use that one.
If it's too big, decrease it.
You can even type a font size in there.
What if you need to…if one of these was really long, like Aunt Martha's Apple Pie, first click on the legend selects all of the items, second click selects just that one, and then you can increase the font size of that one, alright?
So, it's hidden right there in plain sight, right in front of us, on the HOME tab, but not where anyone would think to look over here in format legend entry.
So, thanks for that question.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Today's question is sent in from YouTube, how to change the chart font size in the legend, and I understand that this is going to seem daunting.
I'm going to click the legend and press CONTROL+1.
Especially in Excel 2013, where they have all these different icons here, my general rule is you always start with the chart icon because that's where the important things are, but not for the legend, and you can click through all of these, open all of these, and you're not going to find anything that lets you change the font size.
You would think it would be here under TEXT OPTIONS, the TEXT FILL, no, the TEXT OUTLINE.
There's all of these.
None of these have font size.
Even the TEXT BOX, no font size there, right?
So, you know, it's frustrating that they give us all these different choices over here in the dialog box and none of them let us change the font size, but it is really, really easy when you get right down to it.
Just click on the legend.
Come back to the HOME tab.
In the HOME tab, we have the INCREASE FONT SIZE, DECREASE FONT SIZE.
All of these icons here will work on that text box.
So, to increase the font size, just use that one.
If it's too big, decrease it.
You can even type a font size in there.
What if you need to…if one of these was really long, like Aunt Martha's Apple Pie, first click on the legend selects all of the items, second click selects just that one, and then you can increase the font size of that one, alright?
So, it's hidden right there in plain sight, right in front of us, on the HOME tab, but not where anyone would think to look over here in format legend entry.
So, thanks for that question.
Thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
