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.
