The “More Data Label Options” tool will let you customize the labels further.
To customize data labels for an existing chart, use the Chart Elements button.
One helpful way to point out information is using data labels for a series of data points.
We’ll show you how to use data labels here.
you’re able to choose which series or points to use data labels for and select their positions.
We’ll use a pie chart for our example.
fire up the Add Chart Element drop-down menu in the Chart Layouts section of the ribbon.
Move your cursor to Data Labels and choose a position in the pop-out menu.
The available positions may differ depending on the chart throw in you use.
opt for chart and return to the Add Chart Element drop-down menu on the Chart Design tab.
Move your cursor to Data Labels and pick “More Data Label Options.”
When the Format Data Labels sidebar opens, confirm that you’re on the Label Options tab.
you might then expand the Label Options section beneath and mark the details you want to display.
At the top of the sidebar, use the different tabs to make your changes.
Keep in mind the options vary depending on the data label throw in.
For example, you may want to remove the legend or reposition the chart title.