nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Overlay plots: formating date as m/d instead or d/m/y

rdmagare_ncsu_e

I am creating an overlay plot and want to display dates as d/m (because I do not need yyyy for single year data and it makes the graph look very cluttered).

Unfortunately, d/m does not seem to be an option. I have tried to play with formatting the data in Excel first but without success. I would be grateful for any suggestions. Otherwise, I love the JMP overlay plot capabilities.

Accepted answers

No need for a specific d/m format in JMP 12. Check out the new label nesting options that let you distribute dates on the x-axis over several rows. Labels and tick-marks can be hidden for one or more rows and thereby hiding e.g. the year part.

See this blog post for an example.

All comments

Wendy_Murphrey

You could add a new character column with a formula that would result in the format you are looking for. Here is an example:


Char(Day(:DateTime)) || "/" || Char(Month(:DateTime))

Hope that helps.

Wendy

See this blog post for an example.

rdmagare_ncsu_e

Thank you Wendy and MS for your reply. Downloading JMP 12 and nesting dates worked well for me! I also looked into changing fields to character but this might not work well for me since my sampling dates are not regularly spaced. I appreciate very much the reply.

Steven_Moore

Here's another suggestion since I have struggled with a similar problem: Suppose you want to have a cloumn formatted as month-year (i.e., Jan-05). In Excel, I created a new column using the text function as follows: Suppose I have a column of dates (dd/mm/yyyy) starting at cell A1. I then use =text(A1,"mmm"&"-"&"yy") in the first cell of the new column to get , for example, Jan-07. Then , once the data is improted to JMP, you have to give JMP the order of the months-yr data that you want, otherwise, JMP uses them in alphabetical order.