1 / 15

How to Make a Pie Chart to show Religious and Ethnic Breakdown of a Country

How to Make a Pie Chart to show Religious and Ethnic Breakdown of a Country. Step 1: Open Excel. In A1 type in Religion . In B1 type in Percent Practicing.

nasim-alvarez
Download Presentation

How to Make a Pie Chart to show Religious and Ethnic Breakdown of a Country

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How to Make a Pie Chart to show Religious and Ethnic Breakdown of a Country

  2. Step 1: Open Excel. In A1 type in Religion. In B1 type in Percent Practicing.

  3. Step 2: In the column labeled Religion. List all of the religions that are practiced in your country (if any are under 5% add them together and label them other)

  4. Step 3: In the column labeled Percent Practicing type in the percentage (no percent sign, only the number) that practice that religion. Remember, you need to add up all religions that are under 5% and put them in the Other category.

  5. Step 4: Highlight all cells that contain information (DO NOT HIGHLIGHT EMPTY CELLS) and click on the chart wizard button.

  6. Step 5: Choose Pie Chart from the list. You can then choose either of the six types of pie charts available. You can choose any of these forms.

  7. Step 6: When you have chosen which chart, click next twice. At this dialogue box you change the title of your pie chart. Name it “Religion Breakdown of (Name of your country)”

  8. Step 7: Click on the Data Labels tab. Select Category Name and Percentage. Then click Next.

  9. Step 8: Choose As new sheet. Then click Finish.

  10. Step 9: Select the chart by clicking on it. Then, go to Edit => Copy.

  11. Step 10: Open Fireworks. Go to File => New.

  12. Step 11: Click OK when the dialogue box comes up.

  13. Step 10: Right click on the blank page and select Paste.

  14. Step 12: Make sure to name it something appropriate and save it as a JPEG.

  15. Step 13: Insert the JPEG into your wikispace. • You use this same process for doing the Pie Chart for ethnicities. • The change is when you are setting up excel. Your two headings will be Ethnicity and Percent. • You will put the names of the different ethnicities in your country and the percent practicing. • When it comes time to title your pie chart, title it Ethnic Breakdown of (Your country).

More Related