Tuesday, April 24, 2012

How to Put Excel Data Into a Pie Chart


1. Open a new worksheet in Microsoft Excel. Add headings in the first column down the left side of the page. For instance, if you are making a pie chart of my favorite things, you would write, 'Football,' in cell A1, 'Chocolate,' in cell A2, and 'Television,' in cell A3. Then, put the numbers in the 'B' column. So, using the above example, this would mean you'd put 50% in cell B1 next to 'Football,' a 30% in cell B2, next to 'Chocolate,' and a 20% in cell B3 next to 'Television.'
2. Highlight all of the cells in both columns, from A1 to B3. In Microsoft Excel 2007, simply click the 'Pie' button in the toolbar at the top of your screen. In earlier versions of Excel, and on the Mac 2008 version, click on the 'Insert' menu at the top of the screen and select the 'Chart...' option. A smaller window will pop-up called the 'Chart Wizard.'
3. Hit the 'Pie' button in Microsft Excel 2007, and a drop down menu will appear. Choose the type and style of pie chart you want, and that chart will then be inserted into your spreadsheet. This is the final step to make a pie chart in Excel 2007. If you are using earlier versions of Excel or Excel 2008 for Mac, proceed to the next steps.
4. Click on 'Pie' in the 'Chart Type' menu. To the right of the menu, you will see six different sub-types for how you want your chart to look. Click on the type of pie chart you want and then click and hold the button that says, 'Press and Hold to View Sample.' This will give you a preview of how your chart will look using the data you have entered. When you are happy with your chart, click 'Next' at the bottom of the window.
5. Clarify that the data range is correct in the pie chart. In the space titled, 'Data Range,' click on the gray button with red, blue, and black dots to the right of the blank space. This will shrink the Chart Wizard window. Use your mouse to highlight the area of data you want, including the headings and corresponding numbers. Click 'Next.'
6. Title your chart in the space on the left that says, 'Chart title.' When you are finished, click 'Next.' Finally, choose where you want your chart to be displayed. You can have it displayed directly in the document, or place it in a new spreadsheet. When you have made your choice, select, 'Finish,' and your pie chart will appear in the document.

Blogger news