Thanks John,

I have done that already. I just need to know how you get the chart working.
How do you get the chart to filter automatically based on user choice?

"Jon Peltier" wrote:

Funda -

You could set up the data differently, and use an AutoFilter. One column
would have Year, another for Feature, and the third for the value. Select
AutoFilter from the Data menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Funda" wrote in message
...
Hi,

I need to create a chart that is based on changing values. The Values are
all stored vertically in a Worksheet called Percentage. The chart sheet
contains a selection box where the user can select a specific search and a
date and the selected conditions should be searched for and the chart
should
display results.

Basically, when the user selects X in the first list box and Y in the
second
one, the code should search the Percentage worksheet for all instances of
value=x and y and output.

column Row Feature1 Feature2 Feature3
2000 0.5 8.3 10
2000 1.5 4.6 1
2001 5.5 6 4
2001 0.7 3 20

So if the user selects Feature1 in the year 2001, the values in Feature1
and
2001 should be output.

Any help would be appreciated!

Thanks

Funda