A trick for data labels so that you can link the data label name to a cell within the spreadsheet
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.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
"Adrian and Team. Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude towards De Wet, who hosted the Excel Advanced course.– Gill Robbetze Lonmin