# 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

Try posting a sample of the expected output. It may be easier for developers to understand what you are looking to achieve

Cheers,

S M C

• 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!

## Images

• Re: How to display a conditional point on a chart

Take a look at the examples on this page and see if you can adapt the techniques.

Conditional Format Charts

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

• 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

Excel 2010 Tables, Chart, Points
Select point from drop-down list and
show its marker and data label on chart.
Draw ruler lines to axes.
With macro.
Easy. Not.
http://c3017412.r12.cf0.rackcdn.com/06_08_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

• Re: How to display a conditional point on a chart

\$, thanks Herbds7

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!