How to display a conditional point on a chart

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.

Re: How to display a conditional point on a chart

Sorry for being unclear. Since the actual sheet contains some private stuff and changing it would be a hassle, I've done this pretty drawing to explain what I mean :smile:. [ATTACH=CONFIG]38830[/ATTACH]. Bascially, I want the red dot on the graph to move along the line based on the x and y values entered in the cells.

Those lines going from the point to the axes would be cool to but are not necessary.

I hope this clears everything up. Thanks for the help everyone!

Re: How to display a conditional point on a chart

Thanks AAE, but I don't think anything there is going to help me. Anyone else?

Re: How to display a conditional point on a chart

$, thanks Herbds7