A trick for data labels so that you can link the data label name to a cell within the spreadsheet.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Data Label Trick
One of the problems with data labels is that it sometimes forces you to use its data labels. So just to explain what I mean.
Here is our graph – if I right click on the Series and I say Add Data Labels, you’ll see at the moment it has taken the numbers, you don’t have to use the numbers. I am going to right click on the Data Labels and I am going to say Format Data Labels and instead of using a value, maybe I will use a category name and you’ll see what appears here is the month. If I choose Series Name rather, the Series Name pulls through. What happens if I don’t actually want any of those – if I want one of these labels to say this – Journal Entries. What I can do, is I can activate the labels – just close it – click on the labels once – (I am just going to go out of there) – if you click on them, they all activate. Choose one, click on it again and you’ll notice that only that one is activated. Without doing anything else, just click “equals =” and notice that your “equals =” has appeared in the formula bar. I am just going to go and link it to that, for example. When I click Enter, notice now that the label I have there is actually coming from this cell. So I can, if I want to, go and change this to be something else. For example – Retrenchments – when I click Enter- notice now that this data label changes. So it is quite a nice way to have your chart interact with your spreadsheet.