dynamic chart based on combo box

Hello,

I am trying to create a dynamic chart based on values in a combo box (whenever the user clicks on the value in the combo box, the chart changes).

The data consists of three columns X, Y and Z.
The combo box includes the values of all X.
Whenever a value of X in the combo box is chosen, I need my chart to show Y and Z.
For example if in the combo box the user chooses -353.692, I need my chart to show the values of Y and Z (like the chart in the file attached).
Any help pls?

Thank you Xlbiznes! yes it helps, it is the solution

hello again xlbiznes,
when I click on the last 5 values of the combo box, the chart shows nothing; the chart data does not read the data. any idea why?

and what if the input range of the combo box can vary?
for example instead of (Temp!$D$1:$D$29) we can have the data in (Temp!$D$1:$D$50) etc...

Originally Posted by xlbiznes

Hi,

you need to change the find_me variable in the dynamic_chart() function from double to string.

that solves the issue.

yes it worked! thanks!

Originally Posted by xlbiznes

That is not a issue.

Make sure that the needed data is present in your resultats sheet, which is used to plot your graph.

the data is present in my resultats sheet, but the combo box is not reading values in cells after Temp D29; I need to program the combo box input data so that it reads all cells containing value in column D of temp sheet. is it possible?