Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / August 2006

Tip: Looking for answers? Try searching our database.

Increase size of Legend Key in Pie Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark - 02 Aug 2006 10:15 GMT
Hi,

Does anyone know how to increase the size of legend keys (the colour blocks)
in charts (am presently working on pie charts...)???

I'd prefer not to increase the size of the font...

Thanks in advance :-)
Office Helper - 02 Aug 2006 15:20 GMT
Unfortunately, the size of the legend keys is tied to the font size.  You can
change the color, but there is not a way to change just the size of the
legend key.

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks in advance :-)
Mark - 02 Aug 2006 15:34 GMT
Thanks Office helper... what a bummer.

> Unfortunately, the size of the legend keys is tied to the font size.  You can
> change the color, but there is not a way to change just the size of the
[quoted text clipped - 8 lines]
> >
> > Thanks in advance :-)
Del Cotter - 02 Aug 2006 16:44 GMT
>Does anyone know how to increase the size of legend keys (the colour blocks)
>in charts (am presently working on pie charts...)???
>
>I'd prefer not to increase the size of the font...

Do you want the legend keys to look bigger compared to the labels, or
only compared to the pie? If the latter, consider shrinking the pie
chart itself. If the former, that's not an option in Excel,
unfortunately: the legend keys are automatically scaled to the font of
the largest legend label. You can try to decrease the visual impact of a
large font by choosing one that's thin and greying it down a bit, or you
can choose a font colour of "white" (thus making it invisible), then put
a dummy legend label as a text box next to the big key blocks.

Or, you can introduce a dummy data point with a value of zero, so it
doesn't show in the pie chart. Then give it no border and no pattern so
it doesn't show as a legend key. Finally, click on the legend label and
make *that label only* large, then give it a white font colour, so
neither legend key nor label is visible, but the others are.

You'd better turn the legend border off though, or there'll be an
obvious gap. Also, the labels will be bottom aligned, and you can't
centre align them. You can mitigate it by ticking the "superscript" box
in the font dialogue, though.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

Mark - 08 Aug 2006 19:20 GMT
Thanks for thinking outside the square on this one Del...

Seems thats the only way... fudging it :)

> >Does anyone know how to increase the size of legend keys (the colour blocks)
> >in charts (am presently working on pie charts...)???
[quoted text clipped - 20 lines]
> centre align them. You can mitigate it by ticking the "superscript" box
> in the font dialogue, though.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.