How to create a 3 column chart in Google Sheets with one numerical column and two text columns with customization?

by WeirdElfB0y   Last Updated September 13, 2018 13:03 PM

Consider this data:

+---------+----------+-----------+--+--+
| Food    | Quantity | Type      |  |  |
+---------+----------+-----------+--+--+
| Apple   | 3        | Fruit     |  |  |
+---------+----------+-----------+--+--+
| Spinach | 1        | Vegetable |  |  |
+---------+----------+-----------+--+--+
| Mango   | 2        | Fruit     |  |  |
+---------+----------+-----------+--+--+
| Almond  | 1        | Nut       |  |  |
+---------+----------+-----------+--+--+

I want to convert this to a chart with X and Y axis being the food name and the quantity. But the chart should also show what type of food it is by, for example, color coding that data. So, all fruits will appear red, vegetables green and so on. Is it possible in Google Sheets?



Related Questions






Aggregate data with Sheets pivot table or graph

Updated July 23, 2018 21:03 PM