| T O P I C R E V I E W |
| Govc |
Posted - 07/17/2014 : 04:58:15 AM
Origin Ver. and Service Release (Select Help-->About Origin): 8.5.1 or 9
Operating System: Windows 7, 64 bit
Hi,
I have 3 columns (x,y,label) and I would like to color data in scatter plot according to label value (if label is 100 color it red, if label is 500 color it green,...).
Is there a way not to do that manually point by point?
How to put these new colored data into legend?
Thank you.
Here is example of my data
X Y Label
0,01 1 100
0,02 0,95 200
5E-4 1,00667 1
0,05 0,76 100
0,05 0,73333 200
0,05 0,79333 500
0,1 0,5 100
0,1 0,5 200
0,1 0,508 500
0,1 0,54533 1000
1E-4 0,98667 1
0,01 0,98667 100
0,1 0,725 100
0,1 0,73 200
0,1 0,76 500
0,1 0,81 1000
0,1 0,9 100
0,1 0,95 200
0,1 0,908 500
0,1 0,88 1000 |
| 3 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 07/17/2014 : 1:53:56 PM
Hello,
If you want to connect the same color points, I would recommend
1. Use Worksheet: Unstack Columns to unstack XY data based on info. in Label. Please check the Recalculation mode to Auto so whenever there is change in source sheet, it will be reflected in the unstack result and graph plotted from it.
2. Then Highlight the all unstacked columns in new worksheet to plot them as line+symbol plot.
Then data with same label will be plotted with same color, and even same symbol shape and connected. You can double click the plot and go to Group tab to set the Symbol shape increment to None if you want all use the same shape.
BTW, if you want to connect the line from lowest to highest, in original worksheet, you can right click the Y column and choose Sort Worksheet: Ascending.
The unstack result and graph should update automaticaly.
Thanks, Snow Li
OriginLab Corp. |
| Govc |
Posted - 07/17/2014 : 10:13:40 AM
Thank you, this is exactly what i needed.
From here on, is it possible to connect the same colored points from lowest to highest?
thanks again :) |
| Kathy_Wang |
Posted - 07/17/2014 : 05:19:33 AM
Hi,
First set the column of "Label" as categorical (right click on column header and choose Set as Categorical, then use this column for "color indexing" (http://www.originlab.com/doc/Origin-Help/PlotColor-DatasetControl#Indexing) in the Symbols tab of the Plot Details dialog.
As for the legend, with Origin 9, you could add a legend for the categorical values via menu Graph:New Enhanced Legend, but note that it has been renamed as the "Legend for Categorical Values" in our latest version 9.1, you may refer to our online help file based on latest version:
http://www.originlab.com/doc/Origin-Help/Legend-CateData
In addition, starting from Origin 9.1, you could customize the color indexing list in the color list tab (http://www.originlab.com/doc/Origin-Help/PD-Dialog-ColorList-Tab).
Kathy
Originlab |
|
|
