Article ID: 137528 - View products that this article applies to.
This article was previously published under Q137528
In Microsoft Excel, 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.
To enter the word at a certain point on the axis, you must apply a custom number format to the axis.
ExampleIn 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, follow these steps:
After 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 in Excel 5.0 or 7.0, the Chart menu in Excel 97, or the shortcut menu. You can also add some of these items 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.
Article ID: 137528 - Last Review: August 17, 2005 - Revision: 1.3
Contact us for more help
Connect with Answer Desk for expert help.