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
 Custom formula for axes scaling		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

prashant_agrawall

Belgium
4 Posts
Posted - 03/12/2014 :  05:54:52 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi,

What will be the custom formula (and its inverse formula) for scaling on X axis for the following values:
100, 125, 150, 750, 1350, 1950, 2550, 3150

Thanks
Prashant

SeanMao

China
288 Posts
Posted - 03/12/2014 :  06:52:10 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Prashant,
If you have data set like the following:



Double click on the Y axis to bring up the dialog box and choose Custom Formula as Type under Y Axis:Scale. Input Direct Formula, Inverse Formula as shown in figure below and choose Major Ticks Type as By Dataset and select column A as input.



You will have the label like the figure below:



Sean

Originlab Technical Service
Go to Top of Page

prashant_agrawall

Belgium
4 Posts
Posted - 03/12/2014 :  08:15:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello Sean

Thank you very much for your prompt response. However, I am afraid that I am still facing the issue.

Following is an example data which I wish to plot as column graph:



I wish to obtain a graph like this -



In OriginLab, if I use linear scaling in x-axes I get the following -


I tried custom formula for scaling on x-axes, as shown below -


However, I get the following plot -


Kindly advise if I am doing something wrong.

Thanks
Prashant
Go to Top of Page

snowli

USA
1407 Posts
Posted - 03/12/2014 :  09:14:04 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

Thank you for sending the data and expected graph. It looks you just want to make sure all x values show as tick labels in order.

Select column A and choose Column: Set as Categorical and then highlight column B, C and D to plot column graph will do the trick.

When setting a column as categorical, it will treat the column as text and enough unique value will be mapped to a number from 1 to N. Tick labels will be categorical and read from the categorical column. You can see it from Tick Labels: Bottom subnode of Axis db.

Then you can customize your Y axis to be log10, and also double click plot to customize the fill color list on Group tab.

Thanks, Snow Li
OriginLab Corp.
Edited by - snowli on 03/12/2014 09:27:57 AM
Go to Top of Page

prashant_agrawall

Belgium
4 Posts
Posted - 03/12/2014 :  10:28:29 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello Snow Li

Thank you very much for your response. Your suggestion indeed solves the issue I am facing.

Thanks
Prashant
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