Exceljet

Quick, clean, and to the point

This video comes from our video training for Excel Charts.

How to use data labels in a chart

Tags 
Summary 
Excel charts have a flexible system to display values called "data labels". Data labels are a classic example a "simple" Excel feature with a huge range of options just below the surface. This video provides a general introduction and shows many of the options available to customize the display of data labels in an Excel chart.
Video Transcript 

In this video, we'll cover the basics of data labels.

Data labels are used to display source data in a chart directly.

They normally come from the source data, but they can include other values as well, as we'll see in in a moment.

Generally, the easiest way to show data labels to use the chart elements menu. When you check the box, you'll see data labels appear in the chart.

If you have more than one data series, you can select a series first, then turn on data labels for that series only.

You can even select a single bar, and show just one data label.

In a bar or column chart, data labels will first appear outside the bar end.

You'll also find options for center, inside end, and inside base.

There's also a feature called "data callouts" which wraps data labels in a shape.

When first enabled, data labels will show only values, but the Label Options area in the format task pane offers many other settings.

You can set data labels to show the category name, the series name, and even values from cells.

In this case for example, I can display comments from column E using the "value from cells" option.

Leader lines simply connect a data label back to a chart element when it's moved. You can turn them off if you want.

You can also combine values in data labels and use a custom separator.

Be aware that if you turn data labels off and on, you'll lose any changes you've made.

Like other chart elements, data labels inherit number formatting from the worksheet.

However, you can set your own number format in the Number area.

For example, in this case, I could use a number format with zero decimal places to shorten the display.

Author 
Dave Bruns
Dave, you are an excellent teacher. I've learned so much from your videos (I'm a visual learner), and I appreciate that you provide the text/script for learners who learn best by reading. Your instructions are "pithy"/concise and the length of each video is about all I can absorb at one sitting (depending on the complexity) - Carol
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course