# How can I get a chart per single industry **URL:** \ **Category:** Ask the Community\ **Created:** [March 13, 2020, 12:38pm UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408 "2020-03-13T12:38:40Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\ **Post date:** [March 13, 2020, 12:38pm UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408/1 "2020-03-13T12:38:40Z")
Hi all đź‘‹ I want to use a chart, having 1-x categories (in our case industries). A company may have more than one industry (used as a lookup). Now: how can I get a chart per single industry, even a company may have more than one? Right now it shows me each combination of industry as a value ![Bildschirmfoto 2020-03-13 um 13.38.09](https://global.discourse-cdn.com/coda1/original/2X/4/42ac9d669619cbe10cf4612512fcf76e7f337225.png) ---
**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\ **Post date:** [March 13, 2020, 1:33pm UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408/2 "2020-03-13T13:33:32Z")
Dear @Thomas_Schulz, Formulas is not my strongest point, but did you check out [First()](https://coda.io/formulas#First) ---
**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\ **Post date:** [March 13, 2020, 1:45pm UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408/3 "2020-03-13T13:45:20Z")
If you can share this doc here, or create a sample doc to share here, that will help us see how the data is set up. ---
**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\ **Post date:** [March 14, 2020, 10:30am UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408/4 "2020-03-14T10:30:34Z")
Thanks @Ben_Lee here we go [https://coda.io/d/bottish-Startups\_dm0XuzO-mFU](https://coda.io/d/bottish-Startups_dm0XuzO-mFU) ---
**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\ **Post date:** [March 14, 2020, 10:38am UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408/5 "2020-03-14T10:38:08Z")
Thanks @Jean_Pierre_Traets I am not sure if this helps, but just shared the doc here 🙏 ---
**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\ **Post date:** [March 14, 2020, 4:47pm UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408/6 "2020-03-14T16:47:33Z")
Can you say more about what exactly you need to see in the chart? In particular, what value you need to see on the x-axis and what value you need to see on the y-axis. If it’s just a count of the companies in each industry, you’re Industry table has that info and can be used in a chart, but it sounds like you’re looking for more of a breakdown. ---
**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\ **Post date:** [March 24, 2020, 4:42pm UTC](https://connect.superhuman.com/t/how-can-i-get-a-chart-per-single-industry/14408/7 "2020-03-24T16:42:56Z")
Dear @Ben_Lee really sorry for late reply, you are right I would like to get values for each item (where they can be more than one for a company). e.g. how many companies, founded in year x are in the sector y