The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Add strings in Set Column Value... dialog

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

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"

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000