Microsoft KB Archive/213958

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

Article ID: 213958

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213958



For a Microsoft Excel 98 version of this article, see 191023.

For a Microsoft Excel 97 and earlier version of this article, see 137528.

IN THIS TASK
SUMMARY
 * Add Text to Chart
 * Add Labels, Titles, Legends, and Gridlines



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.

back to the top

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.  Start Microsoft Excel, and then create the following worksheet:

A1: 200

A2: 500

 Select cells A1:A2, click Chart Wizard on the standard toolbar, and then click Finish. Click Value Axis. On the Format menu, click Selected Axis. In the Format Axis dialog box, click the Number tab. Under Category, click Custom. Clear the contents of the Type box.</li> In the Type box, type the following text

[= ] "Min";[= ] "Max"

where  is the minimum data value, and   is the maximum data value.

For example, if the minimum value is 200 and the maximum is 500, type:

[=200] "Min";[=500] "Max"

</li></ol>

NOTE: These steps may not work as expected for pie charts, doughnut charts, and some custom 3-D charts.

back to the top

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.

back to the top

Keywords: kbhowto kbhowtomaster KB213958

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.