I am trying to add a column to a score board, in which I can write custom comments which I want to appear as data labels on a graph (e.g next to June entry, "New manager starts" and such information
I have found a way I believe in Excel 2013, but this doesn't work in 2010 as there is no option to select "Values from Cells" in 2010 as far as I can see:
https://superuser.com/questions/1050461/how-to-add-comment-column-as-special-labels-to-a-graph
Does anyone know of a work around without having to link individual data labels to a cell, one by one (using the formula bar to change text to "=E4" for example) where comments would appear and update just by typing comments into said column?
Many thanks
I have found a way I believe in Excel 2013, but this doesn't work in 2010 as there is no option to select "Values from Cells" in 2010 as far as I can see:
https://superuser.com/questions/1050461/how-to-add-comment-column-as-special-labels-to-a-graph
Does anyone know of a work around without having to link individual data labels to a cell, one by one (using the formula bar to change text to "=E4" for example) where comments would appear and update just by typing comments into said column?
Many thanks
