Data Lookup and Plotting Help

[kazoo]

I have a worksheet with 4 tabs. Each sheet has a series of times in column A
and a series of data in columns B through column? Row 1 contains a text
label for the column.

Each tab has a different series of times in column A as wells as different
series of data with different text labels in the remaining columns.

I want to look up a series of up to 6 text labels, grab the time column (the
times may be different if coming from different sheets) and the data column
for the particular text label and plot the data on a scatter plot.

I have about 60 plots, each with up to 6 series on the plot.

I have been trying all sorts of combinations ways to figure this out all
weekend and am stuck!

Any help would be greatly appreciated!
Thanks!
-Kara

 

[Barb Reinhardt]

You might get more help if you were specific about the following:

1) Where is the text label on the sheet that you want to compile the data on?
2) When you say "Grab the time column", what specifically do you mean? Is
it an exact match to something on another sheet?
3) What are the different series?

I'm guessing you'd need MATCH and VLOOKUP.

 

[kazoo]

Barb--
Here a scaled down version of what my spreadsheet looks like. I think this
answers your questions. If it would be easier to email a sample to you, let
me know.

Thank you for helping me out!
-Kara


Sheet1: Sample Data
A1: blank
A2:A10 times like below
8/14/2008 6:01:00
8/14/2008 6:01:26
8/14/2008 6:01:35
8/14/2008 6:02:00
8/14/2008 6:02:26
8/14/2008 6:02:34
8/14/2008 6:03:00
8/14/2008 6:03:26
8/14/2008 6:04:35

B1:F1 text labels
TC2 TC3 TC4 TC5 TC6

B2:F10 temperature data


Sheet2: Sample Data

A1: blank
A2:A8 times like below
8/14/2008 6:00:01
8/14/2008 6:01:26
8/14/2008 6:02:35
8/14/2008 6:03:00
8/14/2008 6:04:26
8/14/2008 6:05:15
8/14/2008 6:06:16

B1:H1 text labels
PEDACQ1T PEDACQ2T PEDACQ3T PEDACQ4T PEDACQ5T PEDBLKHT1 PEDBLKHT2

B2:H8 temperature data


Sheet3: Sample Data
A1: blank
A2:A8 times like below
8/14/2008 6:00:01
8/14/2008 6:01:26
8/14/2008 6:02:35
8/14/2008 6:03:00
8/14/2008 6:04:26
8/14/2008 6:05:15
8/14/2008 6:06:16

B1:K1 text labels
TH1SAPNLHST TH1SARIBT1 TH1SARIBT2 TH1SCMNTT TH1SCT TH1SDSTBPT1 TH1SDSTBPT2

TH1SDSTBPT3 TH1SDSTHST TH1SHDT

B2:K8 temperature data


Sheet4: Sample Data
A1: blank

A2:A5 times like below
8/14/2008 6:01
8/14/2008 6:02
8/14/2008 6:03
8/14/2008 6:04

B1:F1 text labels
LAB01 LAB02 LAB03 LAB04 LAB05

B2:F5 temperature data

On "Summary" sheet:
A1: blank
A2:A7 listing of text labels I want to plot i.e.
TC2
TH1SARIBT2
TC5
LAB01
PEDACQ1T
TH1SCT

Ideally, in columns B and C would be all the data grabbed for "TC2" i.e.
8/14/2008 6:01:00 30.38
8/14/2008 6:01:26 30.4
8/14/2008 6:01:35 30.39
8/14/2008 6:02:00 30.39
8/14/2008 6:02:26 30.38
8/14/2008 6:02:34 30.4
8/14/2008 6:03:00 30.38
8/14/2008 6:03:26 30.39
8/14/2008 6:04:35 30.4

Then in columns D and E, the dat for TH1SARIBT2 i.e.
8/14/2008 6:00:01 13.53
8/14/2008 6:01:26 13.53
8/14/2008 6:02:35 13.53
8/14/2008 6:03:00 13.53
8/14/2008 6:04:26 13.53
8/14/2008 6:05:15 13.53
8/14/2008 6:06:16 12.01

Etc, through column M

Then, I want to plot all the varying x and y data for the 6 sets of data on
a scatter plot. Also, if there is data that is equal to "-327" I want to
ignore it in the plot since it is invalid data.

If you can help me to get this part to work, I think I can have the text
labels on the Summary sheet in A2:A7 change with a drop down and plotted on a
single plot that will dynamically change instead of plotting all 60 plots.

Thanks again for any help!!!