| T O P I C R E V I E W |
| ovince |
Posted - 06/07/2007 : 01:22:02 AM
Hi,
There is a nice feature in Origin that takes a 2-column worksheet and makes 2D binning with color-coding proportionally to number of data in bins. Is it posible to do the same but to color-code with data from the 3th column - for instance to color-code with the average value (in bins) of the 3th column?
thanks
oliver |
| 5 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 06/08/2007 : 08:28:59 AM
Sorry, I don't know how to do that.
Mike Buess
Origin WebRing Member |
| ovince |
Posted - 06/08/2007 : 12:45:12 AM
how to say .... hmm ... I mean, to bin A(x), B(y) first. This is somthing I do in Origin with
Edit> Convert to Matrix > 2D Binning
Az a result I have a Matrix with number of data in bins. When I plot it, the color-coding is according to this numbers
I would like to do similar thing now like:
1. to bin A(x) and B(y) like above
2. to calculate average of C(y)in each bin
3. color-code NOT using the number of objects in bins BUT the calculated average from step 2.
What you suggest is to plot all data and color-code with the 3th column C(Y) no? But I would like to bine the data first and then to color-code with the average of C(y)s in bins.
|
| Mike Buess |
Posted - 06/07/2007 : 1:24:17 PM
Not sure what you mean by "average of column C in corresponding bin" but I'm guessing that Color Mapping> col(C) is what you want.
Mike Buess
Origin WebRing Member |
| ovince |
Posted - 06/07/2007 : 12:53:13 PM
but I would like to bine A(X), B(Y) and to color-code with the average of column C(Y) in the corresponding bin ... Is it posible? |
| Mike Buess |
Posted - 06/07/2007 : 12:41:11 PM
Hi oliver,
Plot the second column, open Plot Details and set Symbol Color to Indexing> Col(C) or Color Mapping> Col(C).
Mike Buess
Origin WebRing Member |
