Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point. Show
Note: The following procedures apply to Office 2013 and newer versions. Looking for Office 2010 steps? Add data labels to a chart
To make data labels easier to read, you can move them inside the data points or even outside of the chart. To move a data label, drag it to the location you want. If you decide the labels make your chart look too cluttered, you can remove any or all of them by clicking the data labels and then pressing Delete. Tip: If the text inside the data labels is too hard to read, resize the data labels by clicking them, and then dragging them to the size you want. Change the look of the data labels
Use cell values as data labelsYou can use cell values as data labels for your chart.
Change the text displayed in the data labels
Tip: If you want to add a comment about your chart or have only one data label, you can use a textbox. Remove data labels from a chart
Add or remove data labels in a chart in Office 2010
If you have entered custom label text but want to display the data label entries that are linked to worksheet values again, you can click Reset Label Text.
The size of the data label box adjusts to the size of the text. You cannot resize the data label box, and the text may become truncated if it does not fit in the maximum size. To accommodate more text, you may want to use a text box instead. For more information, see Add a text box to a chart. You can change the position of a single data label by dragging it. You can also place data labels in a standard position relative to their data markers. Depending on the chart type, you can choose from a variety of positioning options.
Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point. Add data labelsYou can add data labels to show the data point values from the Excel sheet in the chart.
Click More Data Label Options to change the look of the data labels. Change the look of your data labels
Change the text displayed in the data labels
Tip: If you want to add a comment about your chart or have only one data label, you can use a textbox. Remove data labelsIf you decide the labels make your chart look too cluttered, you can remove any or all of them by clicking the data labels and then pressing Delete. Note: This removes all data labels from a data series. Use cell values as data labelsYou can use cell values as data labels for your chart.
What is data series in a chart?A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits. Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word.
What is a series name in a graph?The data series is the data that appears at the bottom of the graph or chart. It can be the row or column names. It is straightforward to create a bar graph or chart, Line chart, etc. in an Excel spreadsheet.
How do I change the data label in an Excel chart?Edit the contents of a title or data label that is linked to data on the worksheet. In the worksheet, click the cell that contains the title or data label text that you want to change. Edit the existing contents, or type the new text or value, and then press ENTER. The changes you made automatically appear on the chart ...
|