desker.blogg.se

How to make a pie chart in excel when the data isnt showing
How to make a pie chart in excel when the data isnt showing












how to make a pie chart in excel when the data isnt showing how to make a pie chart in excel when the data isnt showing

Change your absolute numbers of beneficiaries into percentages of the total population. Your data should now look something like this:ģ. Change the “male” column of numbers into negative numbers. Your data should look something like this:Ģ. summarize your data into a sex-and-age-disaggregated summary table.

how to make a pie chart in excel when the data isnt showing

What does that mean? It means your data on your beneficiaries needs to include whether each person is male or female, and how old they are. Want to know EXACTLY how to use your data to make this type of pyramid chart? Read on…įirst of all, you need to have data that’s disaggregated by sex and age. One of the best charts to make when you’re reviewing household survey results is the male/female demographics pyramid chart that looks like this:














How to make a pie chart in excel when the data isnt showing