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

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

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

Make a chart based on all the data, without the filter applied. Then select
the chart, go to Options on the Tools menu, Chart tab, and make sure to
check Plot Visible Cells Only.

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


"Funda" wrote in message
...
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