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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Add strings in Set Column Value... dialog
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

bur2000

Germany
36 Posts

Posted - 03/22/2017 :  08:37:44 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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.

aplotnikov

Germany
162 Posts

Posted - 03/22/2017 :  09:34:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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"

Edited by - aplotnikov on 03/22/2017 10:21:01 AM
Go to Top of Page

arstern

USA
237 Posts

Posted - 03/22/2017 :  11:40:20 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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

Edited by - arstern on 03/22/2017 11:42:45 AM
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000