Hi all -
I inherited this workbook, so I am working to figure out how it was created. I'd like to be able to insert a new event and have the chart & associated labels automatically update. However, when I add a new row (as I did here in row 12), the new data plots correctly, but the data labels do not. The new data label doesn't show up at all and all subsequent data labels are off by one row. I suspect the issue is that the code for the data labels is absolute, but I can't
figure out where to go to edit it. The attached file shows both the Before & After on separate tabs.
Thanks in advance for any help you can provide!
ProjectTimeline.xlsx
Bookmarks