| Author |
 Topic  |
|
|
additive
Germany
109 Posts |
 Posted - 01/03/2010 : 4:34:28 PM
|
Origin Ver. 8.1 SR1 / Ver 8.0 SR6
Operating System: Windows XP
Creating a special floating column graph fails with Origin 8.1 SR1 (probably SR0, too). The columns extend from the upper layer border to the actual Y value. Origin 8.0 graphs are ok: the columns extend from 0 to the Y value.
The worksheet looks like the following data structure:
ColA(X) ColB(Y) ColC(Y) ColD(Y) ColE(Y) ColF(Y)
StringValue 0 196,087
StringValue 0 197,747
StringValue 0 1,693
StringValue 0 -2,194
StringValue 0 33,214
StringValue 0 -35,101
StringValue 0 -16,713
StringValue 0 15,993
I need this kind of arrangement in order to get "up and down" columns from a basic zero line and to format each column with an individual color. Let me know if you need a demo OPJ.
Maybe there is another way to do so, but it's strange that Origin 8.1 behaves completely different ...
--Michael |
|
|
additive
Germany
109 Posts |
Posted - 01/03/2010 : 4:42:34 PM
|
Also strange: these floating columns saved with Origin 8.0 are automatically displayed completely different when opening with Origin 8.1.
btw: edit function does not work for me using this forum here ... |
 |
|
|
AmandaLu
439 Posts |
Posted - 01/04/2010 : 04:42:40 AM
|
Hi additive,
This is a bug in Origin 8.1. We have submitted a tracker #14917 and we will fix it as soon as possible. |
|
|
|
additive
Germany
109 Posts |
Posted - 01/04/2010 : 05:43:08 AM
|
| Thank you very much for your quick response! |
|
|
|
ML
USA
63 Posts |
Posted - 01/05/2010 : 11:16:30 PM
|
Hi additive,
We are looking into the problem. In the meantime, I wonder why your data look the way you wrote them, namely that there are only two (nonmissing) values in each of the columns C, D, E, and F. Couldn't you put all the values from columns D, E, and F into column C? If you want to have the pairs of bars have different colors, you can easily accomplish this using a separate column with color values. For example, have total of four columns in your worksheet:
A B C D
A 0 196.087 1
B 0 197.747 1
C 0 1.693 2
D 0 -2.194 2
E 0 33.214 4
F 0 -35.101 4
G 0 -16.713 6
H 0 15.993 6
Select columns A, B, C and make Floating Column plot.
Then bring Plot Details dialog and on the Pattern tab for the (only) dataplot inside the "Fill" groupbox change the Fill Color value to "Index:Col(D)", and hit OK. What this will do is make Origin take colors for each datapoint from column D by treating the corresponding values as indices of colors (1=black, 2=red, 3=green, 4=blue, 5=cyan, 6=magenta, etc.; you can see the same order of predefined colors under "Individual Colors" in many Origin's color chooser controls). If you do this, then 8.1 will not show the problem you describe.
|
|
|
|
additive
Germany
109 Posts |
Posted - 01/06/2010 : 3:25:04 PM
|
Hi,
thank you for further looking into this problem und your workaround idea! Great! I'm not quite sure why I arranged the data this way but I guess it was because of some information set to the column labels (which aren't absolute necessary anymore), but the main problem was to get all this done using OriginC (took me some hours to figure out ... finally I needed a specially prepared template and theme, e.g. for setting the column gap properly, adjust labels and add some error bars).
So the question is does your suggestion work with OriginC? How would it look like?
Once again thanks for your help!
--Michael |
|
|
|
ML
USA
63 Posts |
Posted - 01/06/2010 : 10:28:37 PM
|
Hi additive,
We'll soon post you an OC code example how to create a dataplot from the data as I described in my previous post.
As for the problem with the original data as you posted them, we have made a change for the next 8.1SR which will revert to the old behavior.
Note this about floating column plots: if there are multiple such plots, then every plot uses as "base" the value of the previous plot (i.e. its column), NOT of the first column. And if the value is missing, then this "base" was assumed to be 0.
|
|
|
|
Iris_Bai
China
Posts |
Posted - 01/06/2010 : 10:35:29 PM
|
Hi Michael,
Please click here to see Origin C example for float column plot.
Iris |
|
|
|
greg
USA
1378 Posts |
Posted - 03/23/2010 : 4:37:00 PM
|
| Origin 8.1 SR2 has fixed the problem with Floating Column/Bar plots when there are missing values between levels. |
|
|
| |
Topic |
|
|
|
Floating columns different with Origin 8.1