bottom
Excel 2007 Tips!
     
Your e-mail address is safe!
Close Note
excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Excel2007 Tips
ExcelTips
Home Tips
Money Tips

Newest Tips

Correcting Pale Shading of Selected Cells

Drawing Borders

Converting Numeric Values to Text Values

Specifying Fonts for the Web

Easily Dividing Values by a Set Amount

Adding Text to a Shape

Unwanted Files Loading when Starting Excel

 

Changing Fonts Used in Charts

Summary: When formatting a chart, you might want to change the characteristics of the font used in various chart elements. This can be easily done using formatting techniques you may already know.

When creating a chart in Excel, you can add various elements to the charts, such as titles or data labels. Excel allows you to change the font used to display these elements, if you desire. You can change fonts for these elements individually. To do this, use these steps:

  1. Make sure your chart is visible on the screen and you have selected it. (You do this by clicking on the chart.)
  2. Select the text element whose font you wish to change. For instance, if you want to change the chart's title, click on the title. Excel displays small black squares around the element; this lets you know it is selected.
  3. Display the Home tab of the ribbon.
  4. In the Font group, use the available tools to specify the font characteristics for the element you selected in step 2.