Hello,
I have a historical data set plotted on a line chart (2011-2021), with a primary and secondary y-axis. Every x amount of data points (x not fixed), both of the y-values go to zero, indicating a "shut-in" occurring at that specific date.
Every time a shut-in occurs, I want to annotate this on the plot, whether it be through a data label "shut-in", or adding points on the plot (circle/square/diamond..etc. - doesn't matter), with that point being added to the legend to indicate it's representation.
Is there a way of doing this efficiently? I have a very large data set and it would be tedious/ineffective to do this manually.
See attached excel example for reference.
Thanks,
K
Bookmarks