How To Make A Pie Chart On Excel

A pie chart is a tool to display basic statistical information, and is i of the easier charts to make in Excel. Follow these step-past-footstep instructions to chief creating pie charts, along with tips for customizing the chart and variants you can apply.

What Is a Pie Chart?

A pie chart, sometimes called a circle chart, is a useful tool for displaying basic statistical information in the shape of a circumvolve (each section resembles a slice of pie). Unlike in bar charts or line graphs, you can only display a single data series in a pie chart, and you can't employ zero or negative values when creating i. A negative value volition display equally its positive equivalent, and a nix value simply won't announced.

When creating a pie chart, the clarification of each section is called the category, and the number connected to the category is chosen the value. The categories will add up to 100 pct of whatever is being charted, and the relative size of each category is a visual representation of its relation to the whole. Categories shouldn't overlap. For example, if i category is "Women" and another is "People Over Fifty," there's a pretty good chance that there will exist women over l and therefore, they would be counted twice.

Pie charts are not effective if there are more than 7 categories, just some of the variations bachelor permit charts to brandish a couple more categories. Some experts don't like pie charts because they observe it difficult to accurately compare the angles, only adding labels to the data tin can overcome that issue.

Excel offers a number of variations on the basic pie chart. Steps for creating each are included in the instructions later in this article. The first three options displayed below are listed under the pie chart type, the last is listed under the other blazon.

Pie of Pie and Bar of Pie: Despite their clumsy names, these clever charts make it easier to view smaller values or subsets of the data that make up the category.

3D Chart: Add together depth to a basic pie chart with the 3D option. Depending on the perspective, 3D charts may exist misleading because smaller categories may appear larger than they are, so utilise them with care.

Doughnut Nautical chart: This option looks merely like a pie chart, only with a pigsty in the center. Doughnut charts can take more than ane data serial.

Some Examples of Pie Chart Uses

Pie charts can be used to brandish a lot of different data sets, including things similar factory output past shift, revenue generated by one product compared to total revenue, or water usage by type.

Some other possible examples are trash vs. recycling, types of pets in a town, price range of products sold, census results, revenues past region, or packages shipped by each carrier.

Run into how Smartsheet can help you be more effective

Sentinel the demo to see how you can more effectively manage your team, projects, and processes with real-time work direction in Smartsheet.

Watch a gratis demo

How Do You Create a Pie Chart in Excel?

In this section, we'll testify you lot the steps to create a pie chart in Excel 2011 for Mac. While the images may differ, the steps volition be the same for other versions of Excel, unless they are called out in the text.

1. Open a blank worksheet in Excel. Enter data into the worksheet and select the data. Remember that pie charts only use a unmarried data series. If you lot select the cavalcade headers, the header for the values volition appear as the chart title, and y'all won't exist able to edit the text.

2. Click Nautical chart > Pie (hovering over the chart types volition show brief info about them), so click Pie

3. The pie chart appears on the worksheet.

Other Versions of Excel: The chart types are listed under the Insert tab. This is the only difference.

If you lot realize at that place'south an error in the information, there'southward no need to start over. Just update the information on the worksheet and the chart will automatically adjust to reflect the new data. If y'all've copied the chart to another place (excluding other Microsoft Office program), you lot'll need to insert the updated chart into the other program. If the chart has been copied into a Microsoft Office program on the same computer, the chart copy will automatically update.

If yous only want to display a subset of a long data list, select the data you desire to announced in the chart. The rows don't fifty-fifty accept to be face-to-face. While the examples used in this article all accept information in columns, yous tin also employ data in rows.

How to Read a Pie Chart

Pie charts are easy to read and then trivial explanation is required, merely there are a couple things that volition make them easier to understand. As mentioned before, the data in the chart volition always add up to 100 percentage. If there are no information labels, hovering the cursor over a category (the official proper noun for a section or slice) will brandish the corresponding data.

As well being piece of cake to read, pie charts are useful considering they evidence a lot of data in a small infinite, and they allow an immediate assay of the relationship among each category — both to the the others and to the whole.

How Do You Make a Pie Chart in Excel 2016?

To create a pie chart in Excel 2016, add your data set to a worksheet and highlight it. And then click the Insert tab, and click the dropdown menu adjacent to the paradigm of a pie nautical chart. Select the nautical chart blazon you want to use and the chosen nautical chart will announced on the worksheet with the information you selected.

While the steps are the same as shown above (unless noted), the screenshots volition vary based on the Excel version you apply.

How Exercise You Add Labels to a Pie Chart?

When y'all create a pie chart, a legend is automatically included. If want the category names to appear on or near the nautical chart, right-click on the chart and click Add together Data Labels….

By default, the numerical values are added.

To add other labels, such as the categorical values or the percentage of the total that each category represents, right-click on the nautical chart, and then click Format Data Labels….

Click Labels, and make your selections. Then click OK.

Add together the serial proper noun (the column header for your information) followed past the character that separates each item (a new line, comma, space, colon, or semicolon), and the location where the data labels are displayed.

Click and drag information labels to motility them. You lot can also choose to prove the category color adjacent to the label (similar to the legend), and include lines connecting the information labels if they are moved abroad from the nautical chart. By selecting the other options, such as Shadow, Font, or Fill, you tin tweak the advent of the data labels. Experiment with the options until you find what works.

How to Change the Appearance of a Pie Chart

Quick Layouts, Styles, and Themes

Excel offers Quick Layout and Chart Styles options. Quick Layout is a set of options that you use to format the nautical chart and add elements. Chart Styles are ways to format simply the nautical chart. Curl through them to see if any see your needs.

Excel 2016 and versions more recent than 2011 as well offering themes, which are a collection of preselected fonts and colors. Changing these themes will affect the default appearance of any pie charts created after selecting the theme. To view available theme elements, click the Page Layout tab, so click Colors or Fonts.

Moving the Chart

To motion the chart to another place on the same sheet, simply click on information technology and drag information technology to the new position.

To move the pie chart to some other sheet in the aforementioned workbook, correct-click on the chart and select Move Chart…, then either select an existing sheet, or create a new one.

Resizing the Pie Nautical chart

To change the size of the chart surface area, click on a corner and elevate it to see a larger or smaller version.

Note: In that location isn't a way to adjust the size of the chart within the chart area — Excel automatically does that.

Rotating the Pie Nautical chart

To rotate the pie chart (i.e., put a different slice at the summit), correct-click on the nautical chart, click Format Information Series…, click Options, and enter a value into the Angle of start slice box. You lot'll have to experiment to go the chart to look exactly as you envision.

If the goal is to have a particular slice at the top of the chart, it's easier to rearrange the order of the rows of information, placing the one you desire to appear at the meridian of the chart in the first row of the information cavalcade.

Adding Chart Titles

To add a championship to the chart, click Charts in the ribbon, click Chart Layout, click Chart Title, and chose the location.

To alter the appearance of a championship, click Charts, click Chart Layout, click Chart Title, and so click Chart Title Options…. Here you lot can modify the font style, color, and size, as well equally the background of the box and many other options.

Pie Chart Legends

As noted before, a legend is included past default when the chart is created. To delete the legend, right-click on the legend then click Delete. To change the appearance of the legend, correct-click on it, so click Format Legend…, and make your changes.

If yous delete the legend, merely want it to reappear, click on the Charts tab, click Nautical chart Layout, click Legend, and then choose where you want to place the legend.

Colors, Fonts and Backgrounds

If the default chart appearance or available themes and quick settings don't fit your needs, you can change the appearance of the pie slices by applying dissimilar fonts and adding a color or texture to the groundwork.

Colors
To change the appearance of a pie piece, click on the slice and then double-click it to open the Format Data Bespeak window. Click Fill to change the colour, add together a texture, or fifty-fifty make full the slice's space with a picture.

Fonts
Once you've added data labels, yous tin change the size, color, and other appearance factors. Click the information label once, right-click on it, and click Format Text…. The changes made will bear upon all selected text (i.e. if only one piece'southward label is affected, and so only that slice's label will be changed. If you desire to alter the text on one slice, click on information technology twice).

You can too perform the aforementioned activeness on any other text in the pie nautical chart, such as the legend or a championship.

Backgrounds
If you lot don't like the default background, right-click on an empty space in the chart, so click Format Chart Area…. Not only can you change the background color, merely you can also add textures, gradients, and patterns. You lot can besides change the thickness and colour of the chart'south border, and add other effects (such every bit a drop shadow).

Creating Exploding Pies and Exploding Slices

The exploded pie choice can be easier to read if in that location are a lot of values in your data prepare. If you want to emphasise a particular value, use the exploding piece choice.

There are a couple ways to create exploding pies and exploding slices.

1. Select the Exploded Pie pick when creating the chart.

2. Add together the exploding pie after y'all create the chart. To create an exploded pie, click and drag whatever slice, and the chart will adjust.

3. To explode a single slice, click one time on the pie to select it, click on the desired slice, and then elevate it out of the pie.

Notation: If the 2 clicks are as well close together, the Format Data Point window will announced.

Boosted Pie Chart Formatting Options

In that location are a variety of means to customize a pie nautical chart. Y'all tin create new categories, sort how the slices appear, and add together WordArt.

Resorting By Slice Size
If y'all want to position the slices based on size (e.chiliad. smallest to largest), sort the original data using Excel's sorting tool, and the chart volition automatically update group the chart slices by size.

Combining Small-scale Slices into an "Other" Category
There are two means to combine a number of small-scale categories into one "other" category. To do this hands, enter data into Excel but combine the desired numerical values into a unmarried row and name the categorical value "other."

Below is a more complicated method:

1. Enter data into Excel with the desired numerical values at the end of the list.

2. Create a Pie of Pie nautical chart.

3. Double-click the primary nautical chart to open up the Format Data Series window.

4. Click Options and arrange the value for Second plot contains the concluding to friction match the number of categories you want in the "other" category.

5. Right-click on one section of the secondary nautical chart, click Format Data Signal…, click Fill, then click No Fill up from the color drop downwards.

6. Repeat this for each slice of the secondary plot.

7. If you have data labels, remove them from each section of the secondary plot besides.

8. If in that location are lines connecting the main chart and the now-invisible secondary nautical chart, correct click a line, click Format Serial Lines…, click Line, and click No Line from the color drib down.

WordArt
WordArt is a feature plant in Microsoft Office applications. Yous can apply WordArt to give text an artistic wait (like the example beneath).

While WordArt tin't exist applied to chart elements, you tin create them separately and then paste it into the chart as titles or data labels.

Working with Pie Nautical chart Variations

Equally noted above, at that place are pie nautical chart variations you can apply when dealing with a lot of data for a category or if you want to break out specific data sets. Hither are a few variations you lot can apply to reveal more information in a pie nautical chart.

Pie of Pie and Bar of Pie Charts
To create a Pie of Pie or Bar of Pie chart, the steps are the same as creating a basic pie chart (with the exception of which nautical chart subtype you choose). Editing the nautical chart is the aforementioned as well.

When y'all create a Pie of Pie or Bar of Pie chart, the number of categories in the 2d plot (the smaller pie or the bar) are chosen past default: It's always the final rows in the data set, and the larger amount of the initial set up, the larger number of rows included in the second plot. To change the number of categories in the 2nd plot, right-click on the nautical chart, then click Format Data Serial… and change the value in the Second plot contains the terminal box.

You tin as well alter the default serial by the value (e.chiliad. numbers lower than five), percent (e.g. all values that are less than x pct of the total), or create a custom setting. There's also a setting to modify the size of the second plot relative to the main pie (yous can even make the secondary plot larger than the main pie).

To change the altitude between the two charts, right-click on the chart, and so click Format Data Series… and change the value in the Gap width box.

In a pie of pie chart, the smaller pie can as well have a piece or the whole nautical chart exploded. Follow the instructions for exploding the main plot.

3D Pie Charts
Like the basic pie chart, you tin rotate the 3D pie nautical chart. Instead of rotating one axis, you tin rotate the 3D chart on two axes, and besides change the viewing angle.

The steps for creating a 3D pie are the same equally creating a bones pie, except for what yous choose as the subtype of the nautical chart.

In that location's even a 3D exploded pie selection.

To rotate the 3D pie, right-click on the chart then click 3D Rotation…

• The X axis value rotates the nautical chart around its axis.

• The Perspective arrows will tilt the angle of the chart.

• The Y axis value will have an consequence similar to Perspective.

• The Elevation value volition change the thickness of the chart (deselect Autoscale to change this value).

Doughnut Charts
Unlike the other variation mentioned above, a doughnut nautical chart is not under the pie chart type. Instead, to create a doughnut nautical chart, on the Charts tab, click Other, and then click Doughnut.

Other Means to Create a Pie Nautical chart

If you lot're handy with a ruler and compass, you tin can create a pie chart by mitt, but getting proportions of the slices correct requires a steady hand and a keen eye. There are other programs that you can apply as well Excel, such equally IBM SPS. Nevertheless, the ubiquity of Excel in business environments oft makes information technology a better selection.

You can also create pie charts in PowerPoint and Word, but once the chart is selected, those applications open Excel, so you may too start in Excel and copy the chart into Word or PowerPoint. See the instructions above in the moving a chart section.

Make Ameliorate Decisions, Faster with Charts in Smartsheet

Empower your people to become higher up and across with a flexible platform designed to match the needs of your team — and adapt as those needs change.

The Smartsheet platform makes it like shooting fish in a barrel to plan, capture, manage, and written report on work from anywhere, helping your team be more effective and get more than done. Written report on fundamental metrics and become real-time visibility into work equally information technology happens with whorl-upwards reports, dashboards, and automated workflows built to keep your squad connected and informed.

When teams have clarity into the work getting done, there's no telling how much more than they can accomplish in the same amount of fourth dimension. Attempt Smartsheet for free, today.

Source: https://www.smartsheet.com/pie-chart-excel

Posted by: duboisgivat1997.blogspot.com

Share this post