asked on
excel chart
I would like to make a chart of the attached spreadsheet data that shows the number or percentage of cities with a population of 0-999, 1000-1999, 2000-2999, etc...
What steps do I follow in excel 2013 to make such a chart?
ARcities.xlsx
What steps do I follow in excel 2013 to make such a chart?
ARcities.xlsx
Microsoft ExcelSpreadsheets
Last Comment
samrad1
Grouping by 10,000 doesn't seem to help much either.
92% less than 10k, 9 other groups.
92% less than 10k, 9 other groups.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
With this grouping by 1000, you are going to have a lot of groups, 34 in total.
I have then Grouped the data using a Pivot table, counting the groups.
I have then drawn a Pie Chart (much as I don't like them) but it doesn't really show much. One big slice (approx 62%) for those with less than 1000 and lots of thin slivers for the rest.
If you were to condense the number of groups, eg 0 - 9,999; 10,000 to 19,999 etc, this would help considerably.