How to build histogram and solve problem?

[Frost32]

Hello, everyone! . Could you guys please help me to solve a problem? Here is a question nH9duS7WT8G1VNdzn0bI7A.png . And thats the data for the problem MA2sjKSKRsOVKvQT6xS4NQ.png

[kev_]

Add a second sheet to hold tables
Table1
Cell A2 Enter M
Cell A3 Enter F
Formula in B2
=COUNTIF(refer here to colB in sheet1,A2)

Then in B3 , same for "F"
Put percentages in column C

Table 2
Copy nationality column to column E in sheet 2
Then use remove duplicates (see Data tab) to get unique list
and in F2 copy down
= COUNTIF(refer here to colC on sheet1,E2)
Put percentages in column G

Etc

[Frost32]

Thnka you so much ! But im just wondering, is there any shortcut for this method?

[kev_]

There is no need to quote the whole of a previous post - it fills the thread with clutter

Shortcut? Ask a friend to create the histogram

[kev_]

or perhaps...
...pivot tables - see attached workbook

Click anywhere in a pivot table, click on Insert Tab and then click on one of Chart Types to immediately chart what's in the table

[sandy666]

• Developer Tab
• Excel Add-ins
• Analysis ToolPak - tick
• Analysis ToolPak VBA - tick
• Data Tab
• Data Analysis
• Histogram