Excel 2013 offers more formatting and shape options for displaying data labels in a chart. We'll explore those options and then put them to use. Then, click the Chart Elements icon (the cross icon). That means we'll need to delete a lot of data labels. (We'll work through a simple example with an emphasis on the features rather than sophisticated results.) To add data labels to an existing chart, select the chart. The data labels aren't particularly effective in this chart. For the purposes of this example, we want to keep only one.And how do I get my Excel to calculate and update formulas automatically again?Don't worry, most likely your Excel is all right, and you will get all the answers in a moment.My favorite tricks are using text boxes to add rich formatting to charts (example here) and messing with fonts and colors (some rules here). Can someone imagine using Microsoft Excel without formulas? And hardly anything could compare to the frustration caused by Excel formulas stop working all of a sudden.Slowly click each label that you want to delete twice (don't use a quick double-click) and then press Delete. The second click deletes all but the selected label from the selection.You must delete them individually; you can't create a multi-object selection.
However, they'll still be attached to the same column.The lone data label should be effective just by virtue of being the only one. To move the label, select it and drag it - that part's easy.Obviously, that value has a story to tell or perhaps you have a question to pose. You can also format the value itself using the options in the Font group.The labels are fine, but 2013 has one more effect you might want to know about.You can use shapes to draw attention to labels - Excel calls them callouts.