I have a graph with two Y axis. The value of the primary Y axis is represented as a line and the value of the secondary Y axis is displayed as an area plot.
I am looking for a solution that will mark and display the value of the data set on the primary Y axis (Line) when the value on the secondary Y axis switches from Negative to Positive or Positive to Negative.
I do have a manual process right now that is very time consuming, I am looking to automate this. The manual process involves manually locating these points in the data set and drawing a dot on the line and creating a text box to display the value.
I apologize in advance -- I have a very limited programming background, I will require a fairly detailed explanation if the solution includes VBA coding.
Thank you very much for your help!
I am looking for a solution that will mark and display the value of the data set on the primary Y axis (Line) when the value on the secondary Y axis switches from Negative to Positive or Positive to Negative.
I do have a manual process right now that is very time consuming, I am looking to automate this. The manual process involves manually locating these points in the data set and drawing a dot on the line and creating a text box to display the value.
I apologize in advance -- I have a very limited programming background, I will require a fairly detailed explanation if the solution includes VBA coding.
Thank you very much for your help!
