The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

Scaling secondary axis with custom values

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:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

[quote][i]Originally posted by Martinus[/i]
[br]Dear all,

This is my first post on this forum. Hope someone will be able to help me!

I'm trying to add a secondary axis on my graph, which values are correlated to the first axis' by the formula: log⁡[Cu]=√((log⁡(GLDH)-0,625)/0,145)
GLDH being my first axis, and i'd like the second axis (on the right) to figure [Cu] values on the same graph.

I tried to insert a new layer with axis on the right, and set the scale with custom values. I then inserted my formula, and then the reverse formula (what's that for, by the way??), and i got the error message: "the 2 formulas are not mutually inverse or the From value exceeds the range of Inverse Formula"

Well, i'd like to know whether it's the first or the last! :-) But i checked and re-checked my formulas, and they seem OK to me... I don't see why my "From" value should be out of range... Could someone help me with this? Maybe, there is another solution to display my secondary axis with not-simply-correlated values on the right side of my graph??

Attached are the screen shots for my graph itself, then the "custom formula" box that i tried to fill.

I'd be very glad if someone can take some time to answer me on that issue!
Thanks,

Origin 2020 (64-bit) SR1 
9.7.0.188 (Government)

Operating System: Windows 10 Professional 64 bits (v. 10.0.18362)

[img]https://my.originlab.com/ftp/forum_and_kbase/Images/2020-07-07 22_25_01-Y Axis - Layer 4.png[/img][img]https://my.originlab.com/ftp/forum_and_kbase/Images/2020-07-07 22_25_44-2019-BrebisVigne-sang.opju _ - C__Users_martin.trouillard_Documents_Brebis-Vigne.png[/img]
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Martinus	Posted - 07/07/2020 : 4:52:31 PM Dear all, This is my first post on this forum. Hope someone will be able to help me! I'm trying to add a secondary axis on my graph, which values are correlated to the first axis' by the formula: log⁡[Cu]=√((log⁡(GLDH)-0,625)/0,145) GLDH being my first axis, and i'd like the second axis (on the right) to figure [Cu] values on the same graph. I tried to insert a new layer with axis on the right, and set the scale with custom values. I then inserted my formula, and then the reverse formula (what's that for, by the way??), and i got the error message: "the 2 formulas are not mutually inverse or the From value exceeds the range of Inverse Formula" Well, i'd like to know whether it's the first or the last! :-) But i checked and re-checked my formulas, and they seem OK to me... I don't see why my "From" value should be out of range... Could someone help me with this? Maybe, there is another solution to display my secondary axis with not-simply-correlated values on the right side of my graph?? Attached are the screen shots for my graph itself, then the "custom formula" box that i tried to fill. I'd be very glad if someone can take some time to answer me on that issue! Thanks, Origin 2020 (64-bit) SR1 9.7.0.188 (Government) Operating System: Windows 10 Professional 64 bits (v. 10.0.18362)
6 L A T E S T R E P L I E S (Newest First)
cpyang	Posted - 07/09/2020 : 5:27:44 PM I added ORG-22230 to improve this area, like if parenthesis mismatch, we should be able to check and show correct error message. CP
Chris D	Posted - 07/09/2020 : 10:23:32 AM You have a mismatched number of parentheses in your Inverse Formula. Too many open parentheses. Thanks, Chris Drozdowski Originlab Technical Support
Martinus	Posted - 07/09/2020 : 10:18:48 AM quote: Originally posted by lkb0221 Maybe apply the Y scale range to [200, 1100] first and then config the formula. Cuz from the screenshot your Y is starting from 0 and log(0) is not valid. I wonder if the software is using the scale on the graph to do the checking. Alright, i tried that as well, it now indicates me (did i change something else?) : "From value is computed as missing with specified Direct Formula". But i did check that the From and To values are calculable with the formula i entered... Did that ever happen to you? Why is that function so troublesome?? Is there any other way to rescale an axis the way you want? Thanks for your help!!
lkb0221	Posted - 07/08/2020 : 09:13:48 AM Maybe apply the Y scale range to [200, 1100] first and then config the formula. Cuz from the screenshot your Y is starting from 0 and log(0) is not valid. I wonder if the software is using the scale on the graph to do the checking.
Martinus	Posted - 07/08/2020 : 03:57:58 AM quote: Originally posted by cpyang Can you first try using period as decimal? I wonder if the formula processing code is able to use comma decimal, which other places in Origin will recognize. So use 0.625 instead of 0,625 CP Thank you for answering! Unfortunately, that doesn't work either...
cpyang	Posted - 07/07/2020 : 7:42:13 PM Can you first try using period as decimal? I wonder if the formula processing code is able to use comma decimal, which other places in Origin will recognize. So use 0.625 instead of 0,625 CP

The Origin Forum

Snitz Forums 2000