# Creation of barplot with excel

**URL:** https://forum.qiime2.org/t/creation-of-barplot-with-excel/17245
**Category:** Other Bioinformatics Tools
**Tags:** barplot, export, relative-frequency
**Created:** [October 27, 2020, 9:17pm UTC](https://forum.qiime2.org/t/creation-of-barplot-with-excel/17245 "2020-10-27T21:17:48Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![yanxianl](https://forum.qiime2.org/user_avatar/forum.qiime2.org/yanxianl/32/2039_2.png) [@yanxianl](https://forum.qiime2.org/u/yanxianl)
#### Post date: [October 28, 2020, 10:01pm UTC](https://forum.qiime2.org/t/creation-of-barplot-with-excel/17245/5 "2020-10-28T22:01:40Z")

</div>

Hi Carmen,

I've not done it in excel, but you can also customize your taxa barplot in R. You can import your metadata, feature table and taxonomy into R following the [qiime2R tutorial](https://forum.qiime2.org/t/tutorial-integrating-qiime2-and-r-for-data-visualization-and-analysis-using-qiime2r/4121). There's another R package, [MicrobeR](https://jbisanz.github.io/MicrobeR/), developed by the same author, which allows you to make grouped taxa barplot using the imported data.

I also wrote [an R function](https://github.com/yanxianl/Li_AqFl2-Microbiota_ASM_2020/blob/master/code/functions/make_taxa_barplot.R) based on the MicrobeR pakcage, which allows you to quickly make publication-quality taxa barplots. If you're interested, check [the code](https://github.com/yanxianl/Li_AqFl2-Microbiota_ASM_2020/blob/master/code/06_taxonomy.Rmd) I used for my project.

---

_[View the full topic](https://forum.qiime2.org/t/creation-of-barplot-with-excel/17245)._