topic Re: change size axis increments based on time in Discussions

change size axis increments based on time

ohaynes — Sun, 11 Jun 2023 11:16:54 GMT

I am plotting data over time using an uneven spread of intervals (1 week, 2 weeks, 1 month, 6 months, etc). I would like to make it so the increments on the x axis are sized proportionally to the amount of time; 0-1 weeks, 1-2 weeks being the smallest and 6-9 months, 9-12 months being the largest.

Re: change size axis increments based on time

Thierry_S — Mon, 16 Aug 2021 19:15:04 GMT

Hi, One the simplest method is to create a new X column with the duration as continuous values on a scale of weeks or months whichever is more appropriate to your application.

I would recommend using the Recode function based on your original X values, then change the data type to Numerical and modelling as Continuous.

Best,

Re: change size axis increments based on time

ohaynes — Mon, 16 Aug 2021 20:19:59 GMT

Hi Thierry,

As a new JMP user I don't have the full knowledge about the recode feature. I have attempted recoding the column to something such where 1 week=0.25 months, 2=0.5 months and then months as whole numbers. Then once i change the modeling type to continuous and try graphing, the 2 fractional x values appear after 12 months so it reads 1-12, 0.25, 0.5. Maybe this isn't what you suggested, but could you give me a little more direction on the recode?

Thanks

Re: change size axis increments based on time

Thierry_S — Mon, 16 Aug 2021 20:59:46 GMT

Hi,

That's odd.

Here are a couple of screen captures to show you the steps:

How the recode dialog should look like before any changes:

Recode dialog with new values updated

Finally, in the Column Info window, how the Data type and Modeling type should look like:

Let me know if that does not work either.

Best

Re: change size axis increments based on time

ohaynes — Tue, 17 Aug 2021 11:54:53 GMT

Thank you that did fix the issue with the axis order. Was there a way to distort the axis values themselves so that the time is misinterpreted? Such as the gap between 5 and 6 is the same as 6 and 9 although the time between the two is significantly different. I have included grid lines here, but I mean to pinch the 0 and 0.25 values closer together along the x axis and stretch the 9 and 12 to more accurately show the time spread. Maybe this isnt possible in JMP?

Re: change size axis increments based on time

Thierry_S — Tue, 17 Aug 2021 14:49:04 GMT

Hi,

I'm not sure what you are doing but it seems that the Modeling Type of your X column (i.e., Continuous Time) is still incorrect: from the image you shared it still looks like it is Ordinal or Categorical, it should be Continuous.

Best,

Re: change size axis increments based on time

ohaynes — Tue, 17 Aug 2021 16:42:09 GMT

I have solved the issue after going back through it again. Thank you for your help!