edit chart legend spacing
On Friday, March 1, 2013 1:38:14 PM UTC-5, wrote:
On Tuesday, December 18, 2012 10:28:33 PM UTC-5, jasperdog wrote:
On Thursday, January 29, 2009 7:09:00 AM UTC-5, phocused wrote:
Hi, I am creating an office 2007 pie chart. I have the legend on the right
with a list of entries relating to the data in the pie chart. However the
legend doesnt show all the entries unless I make the chart a really big size.
The Legend looks like this
Daily
Weekly
Monthly
So On
I have noticed that there is what looks to be double line spacing between
each entry in the legend and I want to make the entries closer together so it
looks more like this
Daily
Weely
Monthly
So On
but I can find anywhere that allows you to edit this. i can edit fill, font,
shadow, everything except this one simple thing.
Any ideas?
This is yet another Excel weakness that they refuse to fix. I've read online about how there's a paragraph format section on the HOME tab (there isn't), and about how large line spacing ONLY happens when you have wrapped legend text (it doesn't) and about how you can grab the top or bottom edge to shrink the box and it will magically reduce line spacing (it doesn't). Microsoft employees just refuse to admit error, that's what I think!
You're correct! They cannot admit it. I'm in MS 2010 and it's still a problem.
Yes this is a problem. I found that I can get the spacing to reduce, but you have to make sure none of the labels wrap. Even then the legend text box has to be huge compared to the actual legend and text. If one label wraps, all the labels will be double spaced, which make no since. The wrapped line should just effect the next label spacing.
|