Thursday, January 17, 2013

How to Create a Pie Chart in Excel 2007


1. Enter the data series in an Excel 2007 worksheet. Type the labels for the data series into the cells in one column. Type the numbers for the data series into the corresponding cells in the next column. For example, you might enter the name of each sales team into the cells in column 'A' and their corresponding sales figures into the cells in column 'B.'
2. Select the cells containing the data series by clicking on the first cell in the series, holding the mouse button down and dragging the pointer over the rest of the cells in the series.
3. Go to the 'Insert' tab of the ribbon. Click 'Pie' in the 'Charts' group.
4. Choose the subtype of pie chart you want to use, such as 'Exploded Pie' or '3-D Pie.' The pie chart appears on the current worksheet.
5. Click on the pie chart to select it. Go to the 'Design' tab under 'Chart Tools' to select a different chart style. Go to the 'Layout' tab to add effects such as '3-D Rotation.' Save the worksheet by clicking the 'Save' button on the 'Quick Access Toolbar.'

Blogger news