Forum Discussion
How do I make a chart based on one column of data?
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?
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.
