On the design surface, right-click on the pie and select Show Data Labels.

Note that Excel will automatically reformat the pie chart to update it for this new data point – you do not have to do anything to the pie chart.Ĭlick the “Ctrl-S” buttons to save the spreadsheet over the existing one, or resave the file with a different name to keep the existing file intact.To display percentage values as labels on a pie chart It also adds text, where applicable, which can help viewers understand which pie piece represents what in your spreadsheet.Ĭlick into one of the cells that hold the data for the pie chart. This places formatting such as pie piece percentages onto the chart.

You can change multiple pie pieces to the same color by holding down the “Ctrl” key before you right-click.Įxpand the Chart Layouts section of the ribbon and click an option. This is useful when you don’t want any of Excel’s color choices. Choose “Format Data Point” and select “Fill.” Click a new solid color for the pie piece. Right-click any single piece of the pie chart. This automatically changes a flat pie chart to an exploding one, as you’ve put space in between the pieces. Click “OK” when satisfied with this formatting change.Ĭlick one piece of the pie and drag it out to the edges of the chart’s box. This is also where you would format the pie graph to an entirely different type of chart, such as a bar graph. Scroll to the Pie section and choose a different pie format, such as going from 2-D to 3-D or flat to exploding. Choose new colors that match your business plan, the report’s purpose or your preferred shades.Ĭlick the “Change Chart Type” button on the left of the ribbon. These let you reformat the color of the pie chart in a single click. Review the options in the Chart Styles section of the ribbon.

If you don’t see one of the buttons or featured referenced herein, you probably have clicked off the pie chart and closed the Chart Tools tab, which is only open when the chart is active. Click the pie chart to open the green Chart Tools tab.

Make a pie chart in excel 2010