View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Karen53 Karen53 is offline
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.