Hi. I have a single column of data. It is a baseball roster, a list of player names. They come from multiple towns and and a range of ages.
Column A. Player name.
Column B. Player town.
Column C. Player age.
i.e.:
Joe. Chicago. 12
Jim. Chicago. 12
John. Chicago. 14
James. Chicago. 14
Adam. New York. 12
Andy. New York. 12
Alex. New York. 14
Arthur. New York. 14
I want to do a stacked chart that shows the total player count by age for each town. The x axis would have one stacked column for Chicago (12: 2 count, 14: 2 count), and one stacked column for New York (12: 2 count, 14: 2 count).
How do I sort/split and subtotal the one column out to make this chart? Thanks.
Bookmarks