How do I make a chart based on one column of data?

[BDCanuck]

Hello, 

I want to make a chart based on one column of data. For example, lets say that I wanted to make a chart of the following data. 

Color

red

red

red

blue

blue

yellow

red

red

The chart would be a bar graph, and would indicate that there are five "red" two "blue" and one "yellow".

Is there a way to do this?

[#2]

@BDCanuck Not directly. You need to quantify the color count somehow. If you are on MS365 you could use a singel formula that creates a dynamic array as the basis for the chart.

or you can create a simple pivot table and create the chart on that one. Same result but you need to refresh the pivot table/chart every time the list of colors changes.

The attached file contains examples for both.