Today, Bill reviews an earlier podcast that focused on moving Chart Legends to the top. However, after trying this, a viewer noticed that there was a large space between items in the Legend. Today, in Episode #1593, Bill looks at why this might be happening and how to correct it.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel From MrExcel Podcast, Chart Legend Gaps.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Today’s question is sent in by Jules. Jules has a chart and he says he used my tip to put the legend at the top, so, under CHART TOOLS, LAYOUT, LEGEND, SHOW LEGEND AT TOP, but then he says, hey, there's a big huge gap between some of the series, and I started to think about that.
Well, you know, Excel 2010 doesn't put the gap in.
It handles this pretty.
Well, so, I started to think it might be a problem with the source data.
The gaps appears to be between CENTRAL and WEST, and so I came back to the chart data here.
I press F2.
F2.
So, I select the name of that series, and, check that out, there's a great big space there and we need to close up that space.
Now, what if this had been a formula instead?
You know, it's tough to see how many spaces are in a formula.
If you had a formula instead on here -- I’m on a different worksheet where we have a formula -- you can just wrap that whole formula in the trim function.
Trim gets rid of leading spaces, trailing spaces, and also interior double spaces.
So, if you have BILL, space, space, space, JELEN, it will make it BILL space JELEN.
So, you see that corrects the legend right there.
So, I almost wonder if that is Jule's problem, and now that's if you have a formula.
If you don't have a formula, of course, it's just F2 and then backspace all those spaces away, and press ENTER.
ENTER in it, it fixes itself, and I don't think there's really any other way.
You know, we have a little bit of control over the legend.
Like, we can control the size of the legend, even the font in the legend, but I can't think of any way that we can control, you know, where they occur, if it wraps, or anything like that.
So, I'm thinking that the problem has to be back here in the source data.
Well, hey.
I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
Learn Excel From MrExcel Podcast, Chart Legend Gaps.
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Today’s question is sent in by Jules. Jules has a chart and he says he used my tip to put the legend at the top, so, under CHART TOOLS, LAYOUT, LEGEND, SHOW LEGEND AT TOP, but then he says, hey, there's a big huge gap between some of the series, and I started to think about that.
Well, you know, Excel 2010 doesn't put the gap in.
It handles this pretty.
Well, so, I started to think it might be a problem with the source data.
The gaps appears to be between CENTRAL and WEST, and so I came back to the chart data here.
I press F2.
F2.
So, I select the name of that series, and, check that out, there's a great big space there and we need to close up that space.
Now, what if this had been a formula instead?
You know, it's tough to see how many spaces are in a formula.
If you had a formula instead on here -- I’m on a different worksheet where we have a formula -- you can just wrap that whole formula in the trim function.
Trim gets rid of leading spaces, trailing spaces, and also interior double spaces.
So, if you have BILL, space, space, space, JELEN, it will make it BILL space JELEN.
So, you see that corrects the legend right there.
So, I almost wonder if that is Jule's problem, and now that's if you have a formula.
If you don't have a formula, of course, it's just F2 and then backspace all those spaces away, and press ENTER.
ENTER in it, it fixes itself, and I don't think there's really any other way.
You know, we have a little bit of control over the legend.
Like, we can control the size of the legend, even the font in the legend, but I can't think of any way that we can control, you know, where they occur, if it wraps, or anything like that.
So, I'm thinking that the problem has to be back here in the source data.
Well, hey.
I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
