To create 3-D Pie chart, select 3-D Pie chart from Insert Chart dropdown (Look at the 1 st picture above). Similarly, to hide any of the months plots on the chart de-select he checkbox and click on Apply. To plot the Target data on the chart, select 'Target' series radio button and click 'Apply' button. To add filters to the Pie chart, click on the chart and select 'Chart Filters' command button at the top-right of the chart as dislayed in the picture below. Similarly to change the color scheme, click on the COLOR tab and select different color schemes. Scroll through styles and you would see the preview of each styles. To add style to this chart, click on the chart and select 'Chart Styles' command button at the top-right corner of the chart as displayed in the picture below. The default is immediate data after the label, in this case it is 'Actual', to know how to show 'Target', read the Chart filter topic below. Notice that Pie chart can only show one type of data (In this case either Actual or Target). You will see a Pie chart appearing on the page as displayed in the picture below. To create 2-D Pie chart in Excel, first select the Chart data and go to INSERT menu and click on 'Insert Pie or Doughnut Chart' command dropdown under Charting group on the ribbon.

In this post, we shall learn how to create Pie chart, add filter and style to it. In last post, we learnt about creating Line chart in Excel.

How do i make a pie chart in excel