- Nov 30, 2016
I have a graph that tracks specific tasks in a project against a baseline. I manually draw a vertical line representing a project milestone. When I run a macro to update the data which is attached to the graph I must manually adjust the milestone line to line up with the milestone date again. Is there a way to tie a milestone line to a date in the x-axis so it will automatically adjust if the graph changes?