I cannot say enough good things about Excel 2013’s new charting features. Thank you Microsoft for finally giving us some new options! One of the many new features in Excel charting is the Data Callout Label. In previous versions of Excel, one could easily add a data label to their chart, but these labels were often positioned in a way that made them hard to read, especially if the chart’s fill colors were dark (black numbers on a dark background = zero contrast). The new Data Callout Labels make it easier to show the details about the data series or its individual data points in a clear and easy to read format.
How to Add a Data Callout Label
- Click on the data series or chart.
- In the upper right corner, next to your chart, click the Chart Elements button (plus sign), and then click Data Labels.
- A right pointing arrow will appear, click on this arrow to view the submenu.
- Select Data Callout.
Once the Data Callout Labels have been added, you can re-position them by clicking on their borders and dragging to a new position.
If the Data Callouts appear to clutter your chart, you can move it and/or re-size it by clicking on the resize handles of the label. You can also apply advanced formatting by right clicking the label and selecting Format Data Labels. This will open a task pane on the right side of your screen with options for formatting position, number formatting, and more.
MG Consulting is a software consulting and training company located in the Boston area. For information about Excel training and consulting services, visit www.M-G-Consulting.com.