how do you make a pie chart in excel 2007

You need to add another series (Series 2) of values to form the slots for the dial labels, so again highlight the chart, right-click, select Source Data, and then select the Series tab. Doughnut chart with 90% angle and no color or border on the first slice The doughnut chart should look like the one in the figure. Slowly double-click to highlight each of the other slices in turn, then double-click to get back to the Format Data Series dialog and color the other three bands as required. Click the Patterns tab and set the area and border of this slice to None, then click OK. Set the angle of this slice to 90 degrees. Highlight the doughnut chart, slowly double-click the largest slice to select it, and then select Format Data Series » Options. Placing the chart as an object will make it easier to work with as you are setting up the speedometer. Click Next to go to Step 4, and make sure the chart ends up as an object in the current worksheet (again, this is the default). You can make changes in Step 3 if you need to, but they aren't necessary for this tutorial. Click the Next button to take you to Step 3. Click the Next button to go to Step 2 of the Wizard and make sure your data is charted in rows. Then, under Chart Type, select the first doughnut. In Step 1 of the Chart Wizard, select the Standard Types tab (this should be the default anyway). Now highlight the range B2:B5 and select the Chart Wizard. » View and check the Formulas option to see the formulas, though that's a longer process.

Press Alt/ -~ to show the actual formulas on the worksheet. Doughnut charts work a bit like pie charts, but they can contain multiple series, whereas a pie chart cannot. The first thing you need to do is to set up some data, such as that shown in the figure, and create a doughnut chart. With the hacks in this section, you can create a speedometer chart as well as add a scrollbar from the Control Toolbox toolbar that will alter the chart and change the data in the worksheet simultaneously. A speedometer chart provides a slick way to represent data. Excel's Chart Wizard offers many different types of charts, except, unfortunately, a speedometer chart.

How do you make a pie chart in excel 2007