LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
tranfere vertical data to horizontal tabel dagfinn Excel Worksheet Functions 2 January 29th 05 06:19 PM
Flip the X and Y data on a chart so that the Y data is vertical. Haynesz Charts and Charting in Excel 1 December 3rd 04 01:14 PM
How can I insert a vertical column break between data to create a. Mark Wisdom Excel Worksheet Functions 1 November 23rd 04 04:10 AM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"