T O P I C R E V I E W |
bur2000 |
Posted - 03/22/2017 : 08:37:44 AM Origin 9.0.0 (64bit) SR2 Windows 7
I want to fill a column using the "Set Column Value" dialog with something like 100 K, 200 K, 300 K, 400 K.
Adding the numbers works fine simply by using 100*i. But I have trouble adding the K. I tried things like 100*i Char(75) but it doesn't work.
Obviously I'm missing the syntax for connecting the Char() function to the rest. |
2 L A T E S T R E P L I E S (Newest First) |
arstern |
Posted - 03/22/2017 : 11:40:20 AM Hi,
I am guessing that you want to add the string 'K' next to your values in the column rows for labeling purposes? If so, here are some useful tips for customizing your labels.
1) Customize Labels
-Input your range of data in the columns (i.e. 100i) and input K in the Units row. -After creating your graph, double click the graph to open the dialog box. -Select the plot tab underneath Layer1. -Select the Label tab -Select Enable -Under the Label Form tab --> Select Custom -In the Format String drop down box input %(col(1)[Y]$)%(col(A)[U]$). Where col(A)[Y] --> will specify your values in the column and col(A)[U] specifies your units.
2) Customize tick labels
- Double click the tick axis in your graph to open the axis dialog box. - Select the tick Labels tab - Select Display Tab - Type tab select Numeric (this will display your values from the columns) - In the suffix tab input K (this will input the letter K next to your values) -Select Apply
--Aviel Stern OriginLab |
aplotnikov |
Posted - 03/22/2017 : 09:34:02 AM You can create a column containing row numbers - e.g., col(A). Than you can set values of your target column:
col(A)$+"00 K" |
|
|