Microsoft KB Archive/191023

= XL98: How to Add Text to the X or Y Axis on a Chart =

Article ID: 191023

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q191023





SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, when you try to add text to the x-axis or y-axis of a chart, you are unable to manually edit the numbers on the axis to change them to text.



WORKAROUND
To enter the word at a certain point on the axis, you must apply a custom number format to the axis.

Example
In this example, the word "minimum" will appear for the lowest value of the chart and the word "maximum" will appear for the highest value. To create this example, use the following steps:

 On a new sheet, enter the following:

A1: 1

A2: 1000

 Select cells A1:A2, and press F11 to create a chart. Click the y-axis to activate it. On the Format menu, click Selected Axis.

The Format Axis dialog box appears. In the Format Axis dialog box, select the Number tab. Click Custom in the Category list box.</li> Select any format code and clear the contents of the Type box.</li> In the Type box, type the following text

[=minvalue] "Minimum";[=maxvalue] "Maximum"

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

For example, if the minimum value is 0 and the maximum is 1000, type:

[=0] "minimum";[=1000] "maximum"

</li></ol>

NOTE: These steps work for bar charts, line charts, xy (scatter) charts, and radar charts.

<div class="moreinformation_section">

MORE INFORMATION
Once you have created 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, you can use the commands on the Insert menu or the shortcut menu. Some of these items can also be added when you're creating a chart with the ChartWizard.

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 patterns, colors, and so on. You can also use the commands on the Format menu to format chart items.

Additional query words: XL98

Keywords: kbhowto kbchart KB191023

-

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

© Microsoft Corporation. All rights reserved.