create pie chart in excel from one column

In Excel, replace the sample data with the data that you want to plot in the chart. When you insert a chart into Word or PowerPoint, an Excel worksheet opens that contains a table of sample data. If you don't see the Excel Workbook Gallery, on the File menu, click New from Template.Ĭlick the Insert tab, and then click the arrow next to Chart.Ĭlick a chart type, and then double-click the chart you want to add. From the gallery, you can browse templates and create a new workbook based on one of them. By default, the Excel Workbook Gallery opens when you open Excel. We’ll only be going over the basic chart here, but keep this in mind.Note: The Excel Workbook Gallery replaces the former Chart Wizard. There are many different kinds of pie charts, and they each have distinct visual advantages. That makes it easier for you to present and for them to interpret. A box plot, for example, might leave audiences scratching their heads.īut nearly everyone knows how to read a pie chart. Some graphs and charts include complicated information and aren’t intuitively clear.

It requires little additional explanation. That allows viewers to analyze the data in a snap.Īnd that’s what you’re using a chart for in the first place, isn’t it?ģ. The way in which data is presented by a pie chart makes it very easy to make comparisons quickly. Pie charts are great for showing both a value and a proportion for each category.

Many charts specialize in showing one thing, like the value of a category.

It can show a lot of information at once. If not, though, here are a few reasons you should consider it:ġ. If you’re here, you’re probably already convinced that a pie chart is the best way to present your data.

Create pie chart in excel from one column