Creating a chart

[rota426]

Hey Guys -

I want to create a graph with numbers in column b, but I want them all merged together and treated as percentages, for example if there's three "cools", 2, 4, and 1, treat that as 7. Same with the Warms, hots, and nationals - and group them all together into a pie chart.

Thanks in advance!

[Andy Pope]

You have to summarise the data before charting it.
You can use formula to do that.

[rota426]

I'd like to note that this board has helped me NUMEROUS times - this time just a small thing, but other times quite difficult things...Pope and other Mods, along with all the friendly cats on here - cheers!
Not too often that you find free advice anymore..have a good weekend everyone