Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Lookup and Plotting Help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Lookup and Plotting Help
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. -- HTH, Barb Reinhardt "kazoo" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Lookup and Plotting Help
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!!! "Barb Reinhardt" wrote: 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. -- HTH, Barb Reinhardt "kazoo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting data in Excel | Charts and Charting in Excel | |||
Plotting data from 2 tabs | Charts and Charting in Excel | |||
Plotting two data points as one | Excel Discussion (Misc queries) | |||
problems with plotting "no data" | Charts and Charting in Excel | |||
Plotting data in Excel | Charts and Charting in Excel |