| Author |
 Topic  |
|
|
vonaras
5 Posts |
 Posted - 05/18/2011 : 12:32:23 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.5.0 SR1
Operating System: XP
Greetings,
I have spent several hours trying to figure out how to get the Dollar Sign ($) to display before the data on the label of a graph.
I can see how to do it in the X & Y axis (prefix) but how do I get in the actual data (label)?
Thank you.
-Von |
|
|
vonaras
5 Posts |
Posted - 05/18/2011 : 12:44:38 AM
|
Here is a screen cap of the graph:
 |
 |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 05/18/2011 : 09:56:30 AM
|
Hi Von,
You can specify the custom data label format in the "Label" tab in the Plot Details dialog. Turn ON the "Enable" check box, select "Custom" at the Label Form dropdown list, and put the following format string in the Format String field:
$%(wcol(2)[i]$)
(Here, "2" indicates the column number of your Y data.)
Hope this helps.
--Hideo Fujii
OriginLab |
|
|
|
vonaras
5 Posts |
Posted - 05/19/2011 : 1:04:29 PM
|
Wow - I never would have figured that out on my own!
... but it worked perfectly! 
Thanks so much Hideo!
 |
|
|
|
vonaras
5 Posts |
Posted - 05/20/2011 : 1:29:22 PM
|
Hi Hideo,
Is it possible that you can help me with the format string to place a 'Percentage Sign' (%) after the string?
Thank you. |
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 05/20/2011 : 2:33:19 PM
|
quote:
Originally posted by vonaras
Hi Hideo,
Is it possible that you can help me with the format string to place a 'Percentage Sign' (%) after the string?
Thank you.
Like the prefix case, you can use the literal after the reference. e.g.:
%(wcol(2)[i]$)%
--Hideo Fujii
OriginLab |
|
|
|
vonaras
5 Posts |
Posted - 05/20/2011 : 7:46:59 PM
|
Worked perfectly - thanks!
|
|
|
|
guoweiming
France
23 Posts |
Posted - 06/09/2011 : 09:19:07 AM
|
To Hideo Fujii:
I right click on layer and choose "layer property" item, but can't find ""Label" tab in the Plot Details dialog".
In addition, my goal is to plot some data in format ()% in origin, however, it told me that the data was transformed to "categorical" and was completely out of order...
Can you give some explaination?
Thank you in advance!
PS: my version of origin is 7.5
completely new user of Origin. Any help will be appreciated. |
Edited by - guoweiming on 06/09/2011 09:20:02 AM |
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 06/09/2011 : 10:56:47 AM
|
Hi,
The Label tab which enables you to specify the custom format is a new feature in ver.8.5. In 7.5, you need to create an extra column at the right of Y column with "Label" designation, and fill the line with whatever you want to show as the data labels, e.g., when your Y value is 500, then its corresponding Label cell may be $500. After making this Label column, highlight both Y and Label columns, and choose Plot menu to make a plot.
As you see, this is quite cumbersome, and this is the reason the improvement was implemented in a later version.
--Hideo Fujii
OriginLab |
|
|
| |
Topic |
|
Dollar Sign in Label on Graph