Hi,
I have an excel sheet with various company names in column A, and a further attribute in column B (Gold, Silver, Bronze). Companies can appear more than once in column A, and in column B will have Gold Silver or Bronze status. Is it possible to chart the number of times each different company has a gold, silver or bronze? For example Company 1 has 3 golds, 15 silvers and 5 bronze, Company 2 has 4 golds, 10 silvers and 10 bronze etc...
I can filter the data to see how many of each type the company has, but couldn't figure out how to get this into a chart easily. Any advice appreciated!
I have an excel sheet with various company names in column A, and a further attribute in column B (Gold, Silver, Bronze). Companies can appear more than once in column A, and in column B will have Gold Silver or Bronze status. Is it possible to chart the number of times each different company has a gold, silver or bronze? For example Company 1 has 3 golds, 15 silvers and 5 bronze, Company 2 has 4 golds, 10 silvers and 10 bronze etc...
I can filter the data to see how many of each type the company has, but couldn't figure out how to get this into a chart easily. Any advice appreciated!
