I have a worksheet with a simple linear line chart. I also have a drop-down menu next to the chart which allows the user to select any of the x-axis values and it returns the corresponding y-axis value. Example: The user can choose "15" from the drop down menu and the adjacent cell will display the y-axis value "4" that corresponds to that x value.
What I'm curious about is how to have the point (15,4) show up on the graph as a different color than the line. Basically, I want to be able to highlight the point. If that's easy, it would be really cool if the highlighted point also had lines to each axis appear once it is chosen. I hope that was clear. How can this be done? Thanks in advance for the help.