Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
tranfere vertical data to horizontal tabel | Excel Worksheet Functions | |||
Flip the X and Y data on a chart so that the Y data is vertical. | Charts and Charting in Excel | |||
How can I insert a vertical column break between data to create a. | Excel Worksheet Functions |