HOW TO: Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000

Article translations Article translations
Article ID: 213958 - View products that this article applies to.
This article was previously published under Q213958
Expand all | Collapse all

On This Page

SUMMARY

This step-by-step article describes how to add text to a specific point on a chart in Microsoft Excel 2000.

Normally, when you try to add text to the x-axis or y-axis of a chart, you cannot manually edit the numbers on the axis to change them to text.

To enter text at a specific point on a chart axis, you must apply a custom number format to the axis.

Add Text to Chart

To add text at a specific point on a chart, following these steps.

NOTE: In this example, the word "min" appears for the lowest value of the chart and the word "max" appears for the highest value.
  1. Start Microsoft Excel, and then create the following worksheet:
    A1: 200
    A2: 500
  2. Select cells A1:A2, click Chart Wizard on the standard toolbar, and then click Finish.
  3. Click Value Axis.
  4. On the Format menu, click Selected Axis.
  5. In the Format Axis dialog box, click the Number tab.
  6. Under Category, click Custom.
  7. Clear the contents of the Type box.
  8. In the Type box, type the following text
    [=minvalue] "Min";[=maxvalue] "Max"
    where minvalue is the minimum data value, and maxvalue is the maximum data value.

    For example, if the minimum value is 200 and the maximum is 500, type:
    [=200] "Min";[=500] "Max"
NOTE: These steps may not work as expected for pie charts, doughnut charts, and some custom 3-D charts.

Add Labels, Titles, Legends, and Gridlines

After you create a chart, you can enhance it by adding data labels, chart and axis titles, a legend, and gridlines. To add these items to a chart, click Chart Options on the Chart menu, or click Chart Options on the chart shortcut menu (right-click anywhere inside the chart).

After an item is on a chart, you can double-click the item to display a formatting dialog box that contains various tabs. Each tab allows you to customize the chart item by adding such features as patterns and colors. You can also use the commands on the Format menu to format chart items.

Properties

Article ID: 213958 - Last Review: November 5, 2003 - Revision: 4.1
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbhowto kbhowtomaster KB213958

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com