View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Funda
 
Posts: n/a
Default Vertical Data Extraction

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