From the course: Excel: Charts and Graphs In Depth
Join today to access over 24,700 courses taught by industry experts.
Add and edit data labels - Microsoft Excel Tutorial
From the course: Excel: Charts and Graphs In Depth
Add and edit data labels
- So, if you have a chart with a lot of data on it, it might make sense to add data labels like we have on this chart. Now, adding data labels in Excel is actually really easy, but it can also make things cluttered. So, I'm going to give you my advice on data labels at the end of this video. So, first thing we're going to do is create a new chart. I'm going to highlight cells A1 through C13. I'll click on Insert, and then I'll go to this line and add a 2D chart. Now if you want to add data labels, all you need to do is right click on this line. Go to where it says Add Data Labels, put your mouse over this extender here and hit Add Data Labels. So, now we've added them. Now go ahead and click on any of the data labels. It's actually going to highlight all of them. And here we want to go into the options that's going to allow us to edit them. So, what I'm going to do is, over here where it says Format Data Labels, I'm…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.