Add data labels to a chart. Click the data series or chart. To label one data point, after clicking the series, click that data point. In the upper right corner, next to the chart, click Add Chart Element > Data Labels. To change the location, click the arrow, and choose an option.

If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.

To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options. Click Label Options and under Label Contains , pick the options you want.

If data labels you added to your chart are in the way of your data visualization—or you simply want to move them elsewhere—you can change their placement by picking another location or by dragging them to the location you want.

If someone's entering data inaccurately, or you think a coworker may be confused about how to enter data, add a label. A simple name, such as "Phone," lets others know what to put in a cell, and your labels can also provide more complex instructions. You can add labels to forms and ActiveX controls. Add a label (Form control)

Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit . In the Axis label range box, enter the labels you want to use, separated by commas.

Right-click the category labels to change, and click Select Data. In Horizontal (Category) Axis Labels , click Edit . In Axis label range , enter the labels you want to use, separated by commas.

In Microsoft Excel, there is no built-in command that automatically attaches text labels to data points in an xy (scatter) or Bubble chart. However, you can create a Microsoft Visual Basic for Applications macro that does this.

Use Excel with your keyboard and a screen reader to add a title, data labels, and a legend to a chart. We have tested it with Narrator, JAWS, and NVDA, but it might work with other screen readers as long as they follow common accessibility standards and techniques.

To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. Here are some tips to prepare your data for a mail merge.