# Using chart to display data in multiple columns
**URL:** https://community.glideapps.com/t/using-chart-to-display-data-in-multiple-columns/17883
**Category:** Ask for Help
**Created:** [November 3, 2020, 5:52am UTC](https://community.glideapps.com/t/using-chart-to-display-data-in-multiple-columns/17883 "2020-11-03T05:52:52Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@vishald](https://community.glideapps.com/u/vishald)
#### Post date: [November 3, 2020, 5:52am UTC](https://community.glideapps.com/t/using-chart-to-display-data-in-multiple-columns/17883/1 "2020-11-03T05:52:52Z")
I am trying to display the percent of bacteria that are killed by a specific antibiotic in a specific hospital system. This data is specific to each bacteria, antibiotic, and system. I have tried entering the data as below but not sure if this is the best way.
Trying to have it so user can arrange by a specific hospital or choose a specific bacteria to display the susceptibility number. They could either see the data at a specific hospital or an entire region e.g. the midwest. any ideas?
[Link to file](https://docs.google.com/spreadsheets/d/1WJLw44F3yPxvl9_eFs8LCt3i3cBd9Q5USKKwrdA3ykU/edit?usp=sharing)
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 3, 2020, 8:13am UTC](https://community.glideapps.com/t/using-chart-to-display-data-in-multiple-columns/17883/2 "2020-11-03T08:13:18Z")
Are you specifically talking about data up to row 53 only?
---
### Author:  [@vishald](https://community.glideapps.com/u/vishald)
#### Post date: [November 3, 2020, 12:09pm UTC](https://community.glideapps.com/t/using-chart-to-display-data-in-multiple-columns/17883/3 "2020-11-03T12:09:34Z")
No this is just a sample. This will potentially have hundreds of rows. Ignore the array setup at the bottom. I was just testing something.