Microsoft KB Archive/49140

Adding Data Values to Points on Excel Charts PSS ID Number: Q49140 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 2.10c 2.10d 3.00 | 2.20 3.00

WINDOWS | OS/2

Summary:

There are several ways to add data values to points on charts in Excel. The following are three of those ways:

  Enter unattached text. You can enter unattached text and manually move it to the proper locations.   Attach text. You can choose the Chart Attach Text command and select the Series or Data Point option and specify which Series Number or Point Number you want to display.   Choose the appropriate chart format. If you want to have a line or scatter chart with all the data points labeled, you must first choose Gallery Column and select the column number 7 chart. Then choose the Format Main Chart command and change the chart style from Column to Line or Scatter. 

More Information:

The third method allows you to add the data values to all of the points. The second method allows you to add the data values to specific points of your choice.

For more information on adding text to a chart, see “Chart Attach Text command” in the “Microsoft Excel Reference” manual.

Copyright Microsoft Corporation 1993.