LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 333
Default Legend Line Spacing

Thank you, Del
--
Thanks for your help.
Karen53


"Del Cotter" wrote:

On Wed, 9 Apr 2008, in microsoft.public.excel.charting,
Karen53 said:
I have a chart where the legend is double spaced. How do I change it to
single spacing? Format Legend only has options for patterns, font and
placement. I see nothing for line spacing.


It sounds as though at least one legend label is wrapping due to the
legend area being too narrow. That makes all the other legend labels
wrap a line as well, even if they're not long enough to need it. The
solution is to drag the legend until it's wide enough that none of the
labels wrap.

If the labels are still wide apart, drag the legend so that it's less
tall. The labels occupy all the space the legend area provides equally,
so if the area is too tall, the legends will space out to fit.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reduce the line spacing in the legend box? Line Spacing in Legend Box Charts and Charting in Excel 4 April 2nd 23 07:12 PM
Change line spacing in template Sandra Excel Discussion (Misc queries) 2 February 13th 08 10:21 PM
How do I reduce the line spacing in the legend box? Line Spacing in Legend Box Charts and Charting in Excel 0 August 29th 06 01:00 AM
line spacing in cell dlh New Users to Excel 2 March 24th 06 03:11 PM
Legend Line Spacing Bill Sturdevant Charts and Charting in Excel 1 July 6th 05 12:35 PM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"