If you want to select different parts of your data for the chart, use the Chart Filters. With Chart Styles, you can pick from various color schemes and styles in one handy spot. So you can use Chart Elements to add more items or choose their positions on the chart. The first two buttons correspond to the same buttons in the ribbon. Select the chart, and you’ll see three buttons appear on the right side for Chart Elements, Chart Styles, and Chart Filters. You can add a chart element like a legend or labels, adjust the layout, change the colors, pick a new style, switch columns and rows, update the data set, change the chart type, or move the chart.Įxcel on Windows offers an extra feature for customizing your chart. These tools give you everything you need to customize your chart fully. Once you insert your pie chart, select it to display the Chart Design tab. You’ll see that pie chart pop right into your spreadsheet, ready for you to customize!

You can pick from three 2-D charts or a 3-D pie chart.

On Windows or Mac, select the pie chart type you’d like to use.

In Excel on the web, this is simply a button because there is currently only one pie chart design available.

Go to the Insert tab and click the Pie Chart drop-down arrow.

You can do this easily by dragging your cursor through the cell range.

Select the data you want to use for the chart.

While some of the features for customizing a pie chart differ slightly, the process for creating one is the same in Excel on Windows, Mac, and the web.

With different styles and customization options, you can create a useful pie chart in Excel and an attractive one simultaneously.

How to create pie chart in excel 2010