Question: how to make a pie chart in excel based on cell color?
Answer: First, create a bar or column chart as following screenshot shown (Select data and click Insert > Insert Column or Bar Chart):
Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.