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!