How To Make A Pie Chart  

Open Excel and complete your steps.

Enter Data - Percentages to display in a pie chart

1. In Column A type the different categories for your data.

   

2. In Column B you will want your numbers to show as percentages, so you must set the cell correctly.
3. Click one time on the B at the top of the column. The entire column should be highlighted. Go to Format, select Number.
4. A window will appear. Select Percent and enter the number 0 for precision.

   

5. As you enter the data in column B, remember to type the number with the percent sign or type it in decimal form.

   

6. Remember that the figures in Column B should total to 100%.

1. Select all of your entries in both Columns A and B.

   

2. Go to Options, select Make Chart.
3. A window will appear with the different types of graphs/charts.
4. Select Pie and consider the different options at the bottom of the window.

   

   Try them and see which ones enhance your chart. Remember that you are displaying data to present information! Your chart should be clear.

5. Go to Labels, type in your Title.

   

6. Go to Series, select Label data. You have 3 choices.

   

7. Now you are ready to make your chart. Select OK.

   

1. To change the font of the title or the legend, click on it once so that it is selected and then go to Format in the menu bar.

   

2. You may change the font, size, style and/or color of the text.
3. Remember that your chart should have clearly displayed information.
4. The colors displayed above are the default colors that Claris Works uses. They can be changed very easily to be colors of your choice.
5. Go to View, select Show Tools.
6. On your chart, select one of the small squares of color by clicking on it once. Use the paint palette. Select a different color and you will see that the original color will be replaced. Continue to select the different small squares and adjust the colors.

   

   Save the above spead sheet and print out

   ++++++++++++++++++++++++++++++++++++

   NEW SPREADSHEET

Choose Appropriate Graphic

1. You will need to find a small graphic to use in your pictogram. Look for something that matches your data theme. There are various resources available including:
   • Icon Bazaar
   • Kid's Domain - Icon Mania

   If you choose to download icon files or use icons that you already have on your desktop, go to How To Change Icons to Picts. If you choose to copy graphics from the web, go to How To Use Web Graphics.

2. Once you have chosen a graphic appropriate for your data, consider the size. If it is necessary to make it smaller, open a new paint file in Claris Works, paste the graphic. Go to Transform and select Scale by Percent.

   

3. Type in the appropriate percentage. Adjust if necessary until the graphic is quite small.
4. Copy the graphic to the clipboard.

Enter Data

1. In EXCEL do the below spreadsheet file. In Column A type in labels for your data. In Column B type in the data.

   

1. Select all of your entries in Column A and B.

   

2. Go to Options, select Make Chart.
3. A window will appear with the different types of graphs.

   

4. Select Pictogram and consider the different options at the bottom of the window.
5. Try checking 3-dimensional. It adds a nice effect.
6. Go to Series, check Repeating.

   

7. Your graphic should still be available for pasting from the clipboard.
8. Click one time on the arrow (default graphic) and paste.
9. You will see your new graphic now in place.

   

10. Now you are ready to make your graph. Select OK.

    

11. You can adjust the font, size, color and style of the title if you click one time on it so that it is selected and then go to the menu bar font selections. If you click on the small square so that it is selected you can adjust the color of the bars using the paint colors in the toolbox.