topic Re: How to Overlay scatterplot of data pairs with separate axes in Discussions

How to Overlay scatterplot of data pairs with separate axes

Momentum — Tue, 10 Oct 2023 00:11:00 GMT

I have 7 data sets each with two columns ([Wavelength] and [Absorbance]) comprising continuous numeric data types. I want to overlay the 7 scatter plots showing [Wavelength] on the x-axis and [Absorbance] on the y-axis. Each pair has its own [Wavelength] data interval and range. Currently it is all in the same table (so 14 columns) but I am happy to rearrange data if that is necessary. Please advise.

Re: How to Overlay scatterplot of data pairs with separate axes

jthi — Tue, 10 Oct 2023 04:28:54 GMT

If you have data like this

Stack it

Then create grouping column (depends on how you have named your columns), remove label columns and rename data columns

and then you should be able to plot them

You can also place group on Wrap, Group X/Y or Page depending on your data and what you are trying to plot

Re: How to Overlay scatterplot of data pairs with separate axes

hogi — Fri, 12 Jan 2024 20:53:36 GMT

For 7 distinct combinations which have to be plottet at once, @jthi 's approach is definitely the best:
"Just" reshape the data and let GraphBuilder do the job.

There are other cases, where it may be preferential to still use the same table and accept some manual effort.

Then you can just plot the points twice - with twice all your X values AND all your Y values. Then the plot will look really crowded, because you will get point for every combination of X and Y:

No, open the settings menu of each points plots and just select one combination:

Then you will get a plot like this:

Re: How to Overlay scatterplot of data pairs with separate axes

hogi — Fri, 12 Jan 2024 20:57:23 GMT

A third option:
Generate both plots that you want to overlay and right click into the plot region. Then go to Edit/n Copy Frame Contents - and paste it into the other plot.

Then both plots will show up as an overlay within the same plot.

Unfortunately, the plot cannot be saved.

On the other hand, this is the fastest way to overlay 2 plots with data from different tables - almost the same way one is used to do this Excel.