View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Enlarge a legend key in an Excel chart

This can be done.

1. Add a dummy series to your chart.
2. Select the dummy series in the Legend and increase the Font size for
that one series.
3. Set the font color to white and the background to transparent.
4. Select the legend key and set its border to none and its fill to none.
5. Set the border around the legend to none.

The size of the legend key is controlled for all the series by setting one
of the legends font size!

Regards,
Shane
--
Thanks,
Shane Devenshire


"Jon Peltier" wrote:

No, the little symbol or box is scaled to the size of the text.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"NZJen" wrote in message
...
In the legend box is there any way of making a legend key (the small
coloured
box next to the item) bigger without increasing the size of the text?