I have a scatter plot with straight lines. Y axis is a numerical value and the X axis is a date range (see attached). I have four data series on said chart that correspond to inputted data on a daily basis. I also have a fifth data series that serves the purpose to draw a vertical line intersecting the X axis at todays date. Is there a way to auto populate data labels for each day that corresponds to the data point on each of the four data series that intersect today's date line?
1.png
Bookmarks