View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
[email protected] info@c-hbooks.com is offline
external usenet poster
 
Posts: 1
Default edit chart legend spacing

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.