Topic 30: The Chart Legend: How to resize, move, changing legend font and color?

[seema]

Excel 2007 chart legend is the little box that appears next, above or below the chart. It provides the descriptions what the different colors or patterns mean in a chart. You can so some formatting to the legend such as resize, placement, legend font and color.

To resize a legend box

• Click the chart legend.
• Drag one of its selection handles (legend border) to make it bigger or smaller.

To set the chart legend placement

• Select the chart, if needed.
• On the Chart Tools Layout tab, in the Labels group, click Legend icon and choose the option where you want to position the chart legend.

Similar Threads:

• Topic 27: Thinking of Changing work Background Color? Here is How...
• topic 29: How to Create and Format the Chart Title?
• Topic 7: How to Quickly Move from one Place to another in a Worksheet?
• Topic 18: How to Create an Excel Pie Chart?
• Topic 6: Creating an Excel Chart: The 4 Easy steps!

[seema]

To format the chart legend

• Right-click the chart legend and choose Format Legend.
• From the Format Legend dialog box displayed, do the formation as needed. The available categories are Fill, Border Color, Border Styles, and Shadow.

• When finish, click Close.

[seema]

To format the chart legend font

• Right-click the chart legend and choose Font.
• From the Font dialog box displayed, select the required formatting options.

• Click the OK ****on.