Software

Create axis titles for your Excel 2007 charts

Excel 2007 doesn't have a dialog box that allows you to edit chart and axis titles -- you need to insert them. If the text you want for your axis title is already in your worksheet, you can link to the text rather than retype it. Here's how.

Excel 2007 doesn't have a dialog box that allows you to edit chart and axis titles -- you need to insert them. If the text you want for your axis title is already in your worksheet, you can link to the text rather than retype it.

For example, say you have a chart that compares list prices for a number of office properties. Follow these steps to add horizontal and vertical axis titles to the chart by linking to text in the worksheet:

  1. Click on your chart.
  2. Click the Layout tab under Chart Tools.
  3. Click Axis Titles in the Labels group.
  4. Point to Primary Horizontal Axis Title and select Title Below Axis.
  5. Click in the formula bar and enter = (the equals sign).
  6. Click the cell in your worksheet that contains the label Property and then press [Enter].
  7. Click Axis Titles in the Labels group.
  8. Point to Primary Vertical Axis Title and select Vertical Title.
  9. Click in the formula bar and enter = (the equals sign).
  10. Click the cell in your worksheet that contains the label List Price and then press [Enter].

You can now select the axis titles and format them any way you wish.

Miss a Word tip?

Check out the Microsoft Word archive, and catch up on other Word tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

0 comments