Insert and Customize Pie charts

Insert A Pie Chart

  • Select the data range including the heading of each column or row (do not select the Total column when creating a column chart)

  • Go to Insert Tab > Charts group > click on Pie > click on the desired pie chart


Customize A Pie Chart 

  • Select a pie chart

  • Go to Chart Tools tab > select either Design, Layout or Format tab to customize the chart

  • Do any of the following:

    • To move a pie chart to a new sheet, go to Chart Tools tab > Design tab > Location group > click Move Chart

    • To rotate a 3-D pie chart, go to Chart Tools tab > Layout tab > Background group > click 3-D Rotation

    • To create space between each pie in the 3-D pie chart, hold and drag each piece of a pie chart

    • To apply a predefined style, go to Chart Tools tab > Design tab > Chart Styles group > click a desired style

    • To insert a chart title, go to Chart Tools tab > Layout tab > Labels group > click on Chart Title

    • To modify a chart title, go to Chart Tools tab > click Format tab