Gantt chart data labels in Excel 2010

Ken Holzman's picture

I have created a Gantt chart in Excel and want to label the data points for Duration with the Activity Name. This is easy in Excel 2013 and 2016 because the Format Data Label Options include the option “Value from Cells”.
Unfortunately, I am using Excel 2010, which doesn’t have this option. I can manually add the label by selecting each data label individually and then linking to the appropriate cell in the Formula bar. However, when you do this Excel makes the cell references Absolute and will not allow you to change them to Relative references. As a result, if you sort or filter the list of activities, the data labels don’t change to reflect their new position.
Does anyone know a work around to get the labels to work the way they do in 2013/2016?