COUNTIFS function
4. Create a Graph
Create a bar graph from the summary table you have just made for cardiovascular conditions data, to compare the prevalence of cardiovascular conditions among men, women, and the total cohort.
-
-
- You should end up with a graph with three bars (males, females and total persons).
- Make sure you have a graph title, axis titles and labels and a key (legend).
- Have a go at making the graph more visually appealing by changing colours and fonts.
-
Go to Part 3: Derived variables