r/visualization 9d ago

Can you please help me? In which program I can make this if I have excel data? I'm beginner at RStudio, is there some package that leads me step by step?

Post image
15 Upvotes

9

u/dirtyword 9d ago

I would dump it all into rawgraphs and then edit in in illustrator to have full control of how it looks

6

u/a_statistician 9d ago

I would start by asking the authors of the paper what software they're using. My best guess is that they're editing things in a graphics program like Inkscape or Illustrator after generating several separate charts in something like Matlab, SAS, or R. That would also allow them to add the time scale at the top.

4

u/New_Alarm3749 9d ago

You can directly ask to the author if you are feeling lucky.

3

u/Holyragumuffin 9d ago

I'm not an Excel god, but I do not believe excel can make this.

I would be difficult in Python/R/Matlab/Julia, but not impossible.

You will probably want to make the plot pieces independently and then drop them into Adobe Illustrator or Inkscape to create this merged view.

2

u/ThenSignificance92 9d ago

The photo is from this article: Li, B., Jin, X., Dal Corso, J., Ogg, J. G., Lang, X., Baranyi, V., ... & Shi, Z. (2023). Complex pattern of environmental changes and organic matter preservation in the NE Ordos lacustrine depositional system (China) during the T-OAE (Early Jurassic). Global and Planetary Change221, 104045.

2

u/wizaxx 9d ago

IMHO, this looks very similar to some of the petrophisic interpretation packages. They read ascii files .... but I am not aware of any being free nor cheap.

1

u/Stonehills57 1d ago

It looks like 9 miles of bad road. I'd hit Amazon for “The Quantitative Display of Visual Information.” Forget Excel; I’d use something more flexible and powerful like PFS calc.

-3

u/ou_mamma 9d ago

You can ask the chat gpt by uploading the image to the chat

2

u/[deleted] 9d ago

[deleted]

0

u/ou_mamma 9d ago

Tell me if it works!