summary/analysis data at different worksheet

**only_lonely** · 09-18-2007, 02:46 AM

i got two sets of data,
need to have comparison between them.
how to make a graph from two different work sheet?

need a statistic for it.

**corinereyes** · 09-18-2007, 02:58 AM

Hi only_lonely,

How would you like your summary to be done? Comparing the max temperature value in each sheet and creating a graph out of those values?

**only_lonely** · 09-18-2007, 03:05 AM

comparison sheet 1 and sheet 2.

red color for channel 112, green 113...
so 112 got 2 lines, then have a dot for each line represent max temperature.

**corinereyes** · 09-18-2007, 03:36 AM

Hi only_lonely,

Maybe this example may help you get started. Please see the attached file.

**only_lonely** · 09-18-2007, 03:50 AM

thanks.
but i would like the graph is line style.
so i can see the the changes for each time interval.
up , down slope.

**corinereyes** · 09-18-2007, 04:18 AM

Hi only_lonely,

You can change the chart type by selecting the graph and right click->Chart Type-> select Line Graph, in the Chart sub type, select the type that suites you.

**only_lonely** · 09-18-2007, 04:32 AM

i see.
but i don't want only max value.
i want whole data compare then highlight the max value with a dot.

**only_lonely** · 09-18-2007, 04:34 AM

i see.
but i don't want only max value.
i want whole data compare then highlight the max value with a dot.
so
how to insert the range?
your formula only for max...
=SERIES(Summary!$A$2,Summary!$B$1:$C$1,Summary!$B$2:$C$2,1)

**corinereyes** · 09-18-2007, 04:57 AM

Hi only_lonely,

i'm a little confused now.

In my opinion, we need to summarize the whole data first before we can create a graph based from those values. In this case, we have the max value of each channels from sheet1 and sheet2, and from there we created a graph.

But from my understanding, you need to put the whole data (sheet1 & 2) in a graph? If you will do this, your graph will be unreadable.

It will be better if you will create a simple example of the graph you want and post it here.

**only_lonely** · 09-18-2007, 05:15 AM

no.
purpose of creating this is to campare two sets of data.
i need a plot graph to show the changes.
eg. at 30 secs, 1st unit temperature is 40degC, 2nd unit is 50degC

**only_lonely** · 09-18-2007, 05:19 AM

i raftly sketch this.
will the graph very messy upon finish all?
or, anyone have good suggestion?

**corinereyes** · 09-18-2007, 05:21 AM

Hi only_lonely,

I see. ok. let me see what i can do, hold on, or maybe anyone here in the forum have a better idea.

**corinereyes** · 09-18-2007, 06:18 AM

Hi only_lonely,

Not sure if this is what you need but just to help you get started, see the attached file.

I only included the units for every 30 seconds (both from Sheet 1 & 2) then combined it in 1 sheet.

**only_lonely** · 09-18-2007, 09:35 PM

thanks.your formula is good(filter every 30secs)
how to change it, if i want to filter every 30mins?

**corinereyes** · 09-19-2007, 02:05 AM

Hi only_lonely,

Refer to Sheet1 & 2 column I, the formula is to extract the time
from column A

formula from column j is to extract seconds from column I, then
by using autofilter, filter the rows with 30s and 0s, that will give you all the units for every 30 secs

copy all the filtered units in a separate sheet and plot the graph.

for every 30mins, you could do the same as above, all the 0s are units for every 1 minute, from there you would know the units for every 30 mins.

Im sure there is a better and faster way to do this.

**only_lonely** · 09-19-2007, 04:04 AM

sorry , i still don;t the formula for 30mins.
understand that I column is to trim data and time.
but J column is only for filtering 1mins (10,20,30,40,50) , not 30 minutes.
sorry that my logical skill is not so good, can;t think out a solution.

**corinereyes** · 09-19-2007, 07:11 AM

Hi only_lonely,

Nothing to say sorry about, we are all learning here. Please see the attached file.

Sheet named 1 & 2.

Basically, this is my way of how to extract the units for every 30 secs or 30 mins..etc... but as i've said earlier i'm sure there is a better and faster way to do this.

Column I, filter all 0s (zeros), 0 means units for every 1 minute (column J), if you will add this it will give you 34 minutes, so 34 - 4 = 30, which is in row 181range b181:h181.

**only_lonely** · 09-19-2007, 09:05 PM

OK...finally something hit my head...
i got another solution.
enter number 0,then drag it (copy in series) to number 30.
then hightlight cell np.1-30,drag again but copy cell(not series).
filter no.30...copy these to new sheet and paste values.
LOL.....