how to make a pie chart in excel with two column of data

They allow your audience to see data nicely, neatly, and at a glance.

Pie charts are terrific tools for displaying your data. To move a pie chart, select it and use the four-sided arrow to drag it to its new spot on your sheet.Ĭustomize Your Pie Chart and Display Your Data To resize a pie chart, drag in or out from one of the corners or edges. If you’ve worked with other types of charts in Excel, then you’ll be glad to know it’s just as easy to resize or move a pie chart. Plus, you can hover your cursor over a category to highlight that piece of the pie. 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 not only create a useful pie chart in Excel but an attractive one at the same time.

How to make a pie chart in excel with two column of data