In the past I have used Excel scatter plots to generate scales. Similar to your approach I create two tables, one with the coordinates and labels at which I place large '+' shaped tick marks on a horizontal axis along with the labels, and a second with coordinates where I place smaller '+' marks and no labels. It has worked fine for some custom scales I needed for an article I wrote. I have another article which uses somewhat more complex scales and the Excel approach doesn't look as good. I will likely code up something in Python using your approach as a template. Very timely.
Thanks, Eamonn. I found that these Comments do not allow for images to be attached. So, I've opened up a "chat" which does allow for readers to add images. I'm going to share this to our "Notes" area so that we have a record of the start of the chat. So let me know if that works for you. Also, while not a true user, I believe that python and R have a lot of similarity in their approach so python would be a good language to use for this. But since many (most by now?) people are familiar with Excel it would be great to see some of your Excel results. Thanks!
Nice clean code Mike - very easy to follow.
In the past I have used Excel scatter plots to generate scales. Similar to your approach I create two tables, one with the coordinates and labels at which I place large '+' shaped tick marks on a horizontal axis along with the labels, and a second with coordinates where I place smaller '+' marks and no labels. It has worked fine for some custom scales I needed for an article I wrote. I have another article which uses somewhat more complex scales and the Excel approach doesn't look as good. I will likely code up something in Python using your approach as a template. Very timely.
Thanks, Eamonn. I found that these Comments do not allow for images to be attached. So, I've opened up a "chat" which does allow for readers to add images. I'm going to share this to our "Notes" area so that we have a record of the start of the chat. So let me know if that works for you. Also, while not a true user, I believe that python and R have a lot of similarity in their approach so python would be a good language to use for this. But since many (most by now?) people are familiar with Excel it would be great to see some of your Excel results. Thanks!
Very good information. I am not one for computer languages, or computers for that matter. I'm just old school.
The only computer language I ever began to learn was Fortran IV, which I never was any good at. 😀
I will have to take a look at R as it seems very straightforward.
As an aside, I have started to use AI for writing letters and small reports. I'm just beginning, but it looks promising.
I wonder what happens if you ask AI to just make a standard logarithmic scale? or of a CIF scale on a slide rule (picking a scale at random...)?
I don't know. I'm going to give it a try.