How to Create a Pie Chart in Excel

Pie charts are quite easy to create in Excel 2007 and Excel 2010. In case you're not sure what a Pie Chart is, here's the basic one you'll be creating. Later, you'll add some formatting to this:

An Excel 2007 Pie Chart

To make a start, you need to highlight some data. If you've been following along with the previous tutorials, then you'll have some viewing figures data. You've created a 2D chart with the BBC data. This time we'll use the ITV data. If you don't have this data, create the following simple spreadsheet. The cells to use are D4 to E14:

The Data for the Excel 2007 Pie Chart

The Charts Panel

Click the down arrow and select the first Pie chart:

Available Pie Charts in Excel 2007

A Default Pie Chart

To get different colors, make sure that your chart is selected and locate the Chart Style panel:

Chart Styles in Excel 2007

Click the down arrow to the right of the Chart Style panel to reveal the available styles :

Available Pie Chart Styles

We've gone for the second one, Style two. The chart will then look like this:

Style Two Pie Chart

 

It looks pretty good for just a few mouse clicks! We can still do a bit more to it, though. In the next part, you'll see how to add the viewing figures to the pie chart segments.

Add Data Labels to a Pie Chart in Excel 2007/2010 -->