# To draw Alpha Rarefaction plot in Excel.

**URL:** <https://forum.qiime2.org/t/to-draw-alpha-rarefaction-plot-in-excel/10173>\
**Category:** Other Bioinformatics Tools\
**Tags:** alpha-rarefaction\
**Created:** [June 11, 2019, 12:52pm UTC](https://forum.qiime2.org/t/to-draw-alpha-rarefaction-plot-in-excel/10173 "2019-06-11T12:52:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dperez](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/d/d6d6ee/32.png) [@dperez](https://forum.qiime2.org/u/dperez)\
**Post date:** [June 11, 2019, 12:52pm UTC](https://forum.qiime2.org/t/to-draw-alpha-rarefaction-plot-in-excel/10173/1 "2019-06-11T12:52:38Z")

</div>

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.

Thanks.

---

<div class="post-metadata">

**Author:** ![ebolyen](https://forum.qiime2.org/user_avatar/forum.qiime2.org/ebolyen/32/11_2.png) [@ebolyen](https://forum.qiime2.org/u/ebolyen)\
**Post date:** [June 11, 2019, 4:40pm UTC](https://forum.qiime2.org/t/to-draw-alpha-rarefaction-plot-in-excel/10173/2 "2019-06-11T16:40:20Z")

</div>

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.
