| T O P I C R E V I E W |
| barni0606 |
Posted - 07/17/2013 : 03:58:13 AM
How can i create a legend in a bar plot with values from a special column in my worksheet?
It is not possible to chosse this option in the menue and I donīt understand the commands for the default mode. |
| 9 L A T E S T R E P L I E S (Newest First) |
| bergschofal |
Posted - 07/03/2015 : 02:51:38 AM
Hello Snowli,
perfect. This works.
Thanks |
| snowli |
Posted - 07/02/2015 : 10:37:38 AM
Hello,
I tried in 9.0 and as you said the @wt isn't supported in 9.0. It was added later.
As a workaround, in 9.0, you can use
%(2@W, 3, 4) -- 2nd plot's corresponding worksheet. 3th colum, 4th row.
$(%(2@W, 3, 4), .2) -- using this $( , .2) to keep 2 decimal places. Using $( , *3) to keep 3 significant digits.
Thanks, Snow |
| bergschofal |
Posted - 07/02/2015 : 03:35:40 AM
Hello Snowli,
Somehow the link @WT does not work. I also looked at the blog you suggested and downloaded the file. Also in this file the link to the desired cell does not work. But it is exactly what I need :-)
@cdrozdowski111: doesn't give me the value of the desired cell back....gives back the x-Value of my chart in the x's-Row "\l(2) %(2,@D,x)"
I use OriginPro 9G 64bit.
Thanks
quote:
Originally posted by snowli
Please read this blog about how to use metadata or some cell value in worksheet to annotate the graph.
http://blog.originlab.com/graphing/annotating-graphs-with-worksheet-metadata
Note: Legend is just a special text object in Origin so the syntax also works for legend.
e.g. %(2, @WT, 3, 4) -- 2nd plot's corresponding worksheet. 3th colum, 4th row.
$(%(2, @WT, 3, 4),.2) -- using this $( , .2) to keep 2 decimal places. Using $( , *3) to keep 3 significant digits.
Thanks, Snow
|
| snowli |
Posted - 06/23/2015 : 4:57:14 PM
Please read this blog about how to use metadata or some cell value in worksheet to annotate the graph.
http://blog.originlab.com/graphing/annotating-graphs-with-worksheet-metadata
Note: Legend is just a special text object in Origin so the syntax also works for legend.
e.g. %(2, @WT, 3, 4) -- 2nd plot's corresponding worksheet. 3th colum, 4th row.
$(%(2, @WT, 3, 4),.2) -- using this $( , .2) to keep 2 decimal places. Using $( , *3) to keep 3 significant digits.
Thanks, Snow |
| cdrozdowski111 |
Posted - 06/23/2015 : 09:55:24 AM
Hi bergschofal,
Try this where 2 represents 2nd plot:
\l(2) %(2,@D,1)
Does this solve your issue?
Thanks,
Chris Drozdowski
Originlab Technical Support |
| bergschofal |
Posted - 06/22/2015 : 6:13:57 PM
Hello Hideo,
I'm a little late, but need some help.
Is it possible to edit these legend entry not writing 'book1' but
as @W. Somehow it doesn't work and I have lots of books, from whome I would like to get a text in a column in the legend...
example:
\l(2) %(book1,1,1) --> leads to the wanted number
\l(2) %(@W,1,1) --> leads to @@@
Thanks |
| Hideo Fujii |
Posted - 07/18/2013 : 10:14:32 AM
Hi barni0606,
By setting the proper column and row numbers, the substitution notation should work as in the screenshot below.
(Of course, in this case, the legend element is a text, you don't need the formatting notation $(....). )
For the details of the substitution notation, see:
http://wiki.originlab.com/~originla/ltwiki/index.php?title=LabTalk:Substitution_Notation#Worksheet_Column_and_Cell_Substitution
--Hideo Fujii
OriginLab |
| barni0606 |
Posted - 07/18/2013 : 09:06:59 AM
Hi,
Sorry that doesnīt work like i would like it. I have got three columns. In the first column are the names of the examples which should be in the legend. In the columns 2 and free are the x and y values. I hope this helps for the solution. |
| Hideo Fujii |
Posted - 07/17/2013 : 12:49:33 PM
Hi,
You can use the substitution notation in the legend textto refer to a value of a specific dataset value. For example:
$(%(Book1,2,3),.2)
(or $(%([Book1]Sheet1,2,3),.2) ) This means the third row in the second column in Book1. (Here, ".2" is a format element to set the decimal place to 2.
Then, right-click the legend, select "Programming Control" flyout, and set the "Link to(%, $) Substitution Level" to 1.
(Note: In this screenshot, I have made the "special point" at the third bar by SHIFT+doubleClick to emphasize it.)
Hope this helps.
--Hideo Fujii
OriginLab
Post note: %([Book1]Sheet1,2,3,.2) also should work. |
|
|
