To draw Alpha Rarefaction plot in Excel.

Hi everyone!

I would like to know how I can draw the alpha rarefaction plot in excel. What I did was to download the CVS that QIIME2 viewer offers. With the data, I tried to draw the plot (I made the average of all the values with the same sequencing depth per sample) but the plot I obtained is different.


Hey @dperez,

I’m not good at Excel, but some screenshots of your approach might help others (who are good at excel) understand what you are doing with the plot functions.