| T O P I C R E V I E W |
| hapes |
Posted - 10/07/2005 : 4:27:44 PM
hi there,
having a hard time with the automization of legends. my legend should have the text of a specific cell out of the corresponding worksheet ffor the plotted graph. that means, i have multiple layers in my graph window and the data are from different worksheets. the legend text should always be the content of the worksheet cell in the second column and first row of the worksheet, which have the data for the plotted curve.
I use the following legend text:
\l(1.1) %(%(1.1,@w),2,1)
\l(1.2) %(%(1.2,@w),2,1)
\l(2.1) %(%(2.1,@w),2,1)
... but instead printing the cell content, it plottes the column name?
thanks for help,
hapes |
| 3 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 10/08/2005 : 07:09:03 AM
As shown in the figure, %(%(1.1,@w),2,1) and $(%(1.1,@w)!cell(1,2)) both give the correct labels in 7.0E SR4. The last line shows how to show a string value. Note that \v() is necessary only in special cases such as file paths.
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 10/08/2005 08:55:44 AM
Edited by - Mike Buess on 10/08/2005 10:17:24 AM |
| hapes |
Posted - 10/08/2005 : 04:00:10 AM
Thank you Mike,
your suggestion works with version 6.1 but not with 7.0 ?? Do not now why? I have compared the Origin.ini file for the legend definition, but they are similar.
Therefore trying to describe what happens:
\l(1.1) %(CT25norm,1,1) output in legend: -150 (that is what I want)!
but problem with this is, once i rename my
worksheet it does no longer take the name
"CT25norm" and thus I don't get any values!
therefore working with @w substitution.
\l(1.1) %(1.1,@w) gives me the worksheet name "CT25norm"
\l(1.1) %(%(1.1,@w),1,1) therefore working with the left line should
solve my problem, but doesn't.
it gives me in the legend preview window:
"column_name1.1,@w,1,1"
but once i close the text control window and
reopen it, the above line is changed to
\l(1.1) %(1.1,@w,1,1)
which leads to wks name "CT25norm"
therefore working with your line:
\l(1.1) $(%(1.1,@w)!cell(1,1)) leads to "--CT25norm!cell(1,1)"
???? do not understand what happens within origin 7.0 ??
thanks for help - hapes
P.s. also if the content of the referenced cell(1,1) is not numeric rather than beeing text the "$" command does not work - what is needed in this case?
|
| Mike Buess |
Posted - 10/07/2005 : 5:30:23 PM
Try this...
\l(1.1) $(%(1.1,@w)!cell(1,2))
\l(1.2) $(%(1.2,@w)!cell(1,2))
\l(2.1) $(%(2.1,@w)!cell(1,2))
Mike Buess
Origin WebRing Member |
|
|
