Vertical Data Extraction

[Guest]

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

 

[Jon Peltier]

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/
_______

 

[Guest]

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]

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/
_______