I tried to google this but no luck. It is easy to add a pie chart when you have prcentace data but what if you just have a list of partially repeated data?
For simplicity imagine there is a table in Excel which represents all cars in a town. One of columns is 'color'. How is it possible to add a pie chart representing colors of cars without calculating percentage? And, it is important to mention that if comeone will add a pink or any new color car first time into the table, the pie chart should automaticaly have one more slice.