sponsored ads

how to increase the size of the legend key in excel 2010

sponsored ads

I have a chart with legend displayed. I would like til increase the size of the legend key, without increasing the legend text.thanks. Asked Apr, 23 2011
add commentflag 

sponsored ads

answer this question

1 answers

The legend key size is related to the legend font size.
If you have a bar/column chart then you can add a dummy series as line chart which will cause the square legend markers to become rectangles.

reas more:www.pcreview.co.uk/forums/excel-2007-possible-format-legend-key-t3911292.html Answered Apr, 23 2011
add comment|flag 
vote up 1 vote down

  1. Select any cell in the row you want to adjust. If you select a cell range that includes cells in multiple rows, you can adjust the row height for more than one row at a time.
  2. Display the Home tab of the ribbon.
  3. In the Cells group, click Format. Excel displays a selection of choices.
  4. Click Row Height. Excel displays the Row Height dialog box. 
  5. Adjust the value in the dialog box to reflect the desired row height.
  6. Click on OK.
Answered Nov, 12 2010
vote up 0 vote down

you can have a try with this method, hope it is helpful~~www.ehow.com/how_5859865_edit-legend-microsoft-excel.html Answered Nov, 26 2010
vote up 0 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

Guitar Chord Legend 1.0

Last Updated: May 25, 2012
License: Shareware
Filesize: 1.88MB

Continue to downloadPower by Afreecodec.com