Forum Discussion
BDCanuck
Mar 14, 2023Copper Contributor
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 ...
Riny_van_Eekelen
Mar 14, 2023Platinum Contributor
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.