For now, let's just highlight a certain piece ofĭata that interests us. There are many properties of the chart that we can adjust to get just the right kind of look. The image below, if you want to see an example. While the chart is selected, the chart tools contextual tab will display in the ribbon. Note that it displays a legend thatĬorresponds to the column headings for our data. The following pie chart is inserted into the worksheet. We are then presented with a small thumbnail gallery showing the types of pie chart we can insert.įor our example, let's select the first 3-D pie chart. Select the data including the column headings and then click Insert > Pie. Below is some date about household expenses that we will use to

Let's get stuck in and create a pie chart, and we can explore the options as we go. If you use column headingsįor your data, for example, these headings are used to key the pie chart's legend. Pie charts show the relative sizes of items in one data series as a proportion of the whole.īecause only one data series is used to source the chart, the data should be arranged in either one column or one row. On specific slices by pulling them out of the pie chart. Once you've created one, you can rotate the slices for different perspectives and you can also focus

The categories represent portions of the whole pieĮxcel pie charts are really flexible.

All of the values in the series are greater than 0.

There is only one data series to represent.You should consider using a pie chart when all of the following criteria are met: X-axis order or when they represent separate measurements. You use it when the values being charted are not in Scatter Chart - also known as an X Y Chart, this chart compares pairs of values.Area Chart - emphasises differences between several sets of data over a period of time.Bar Chart - good for comparing multiple values.You can use it when values can be added together or when you have only one Pie Chart - displays the contribution of each value to a total.Line Chart - used to display trends over time.Column Chart - used to compare values across categories.So how do we decide when to use a pie chart? It might help if we describe what each chart type is useful for. There are many different types of chart available to us in Excel 2007, and a pie chart is but one.

How do i make a pie chart in excel 2007