How to Make a Pie Chart in Excel (Only Guide You Need)
Jan 24, · How to Create and Format a Pie Chart in Excel Enter and Select the Tutorial Data. A pie chart is a visual representation of data and is used to display the amounts of Create the Basic Pie Chart. The basic pie chart is a plain, unformatted chart that displays the categories of data, a Add the. In your spreadsheet, select the datato use for your pie chart. For more information about how pie chart data should be arranged, see Data for pie charts. Click Insert> Insert Pie or Doughnut Chart, and then pick the chart you want. Click the chart and then click the icons next to the chart to add finishing touches.
This article explains how to make a pie chart in Excel for MicrosoftExcel,and A pie chart is a visual representation of data and is used to display the amounts of several categories relative to the total value of all categories. Pie charts are used, for example, to show the production of one factory in relation to the output of the company or to show the revenue generated by one product relative to the sales of the entire product line.
Before you create a pie chart, enter the chart data. Then, highlight the data you want to use in the pie chart. To follow along with this tutorial, enter the data shown in the image above into a blank worksheet. The basic pie chart is a plain, unformatted chart that displays the categories of data, a legend, and a default chart title. To create a pie chart, highlight the data in cells A3 to B6 and follow these directions:.
On the ribbongo to the Insert tab. Select Insert Pie Chart to display the available pie chart types. Hover over a chart type to read a description of the chart and to preview the pie chart. Choose a chart type. For example, choose 3-D Pie to add a three-dimensional pie chart to the worksheet. Edit the default chart title to add a more suitable one.
Select the default how to identify a false prophet title. A box appears around the title. Click on the text to put Excel in edit mode and place the cursor inside the title box. Press Delete or Backspace to delete the existing text.
Type a chart title. To separate the title into two lines, place the cursor between two words and press Enter. For example, place the cursor between and Revenue. There are how to make pie graphs on excel different parts to a chart in Excel, such as how to make pie graphs on excel plot area that contains the pie chart representing the selected data series, the legend, and the chart title and labels.
All these parts are separate objects, and each can be formatted separately. To tell Excel which part of the chart you want to format, select it. If you don't get the desired what is la santa muerte used for, the right part of the chart was not selected. A common mistake is selecting the plot area how to catch a turtle in a pond the center of the chart when the intention is to select the entire chart.
The easiest way to select the entire chart is to select a corner of the chart. If you make a mistake, use the Excel undo feature to remove the mistake. Then, select the right part of the chart and try again. To add data labels to a pie chart:. Select the plot area of the pie chart. Select Add Data Labels. In this example, the sales for each cookie is added to the slices of the pie chart. When a chart is created in Excel, or whenever an existing chart is selected, two additional tabs are added to the ribbon.
These Chart Tools tabs, Design and Format, contain formatting and layout options specifically for charts. To change the color of the slices, background, or text:. Select an area on the chart background to select the entire pie chart.
Hover over a row of colors to preview the color in the pie chart. Choose a color. The pie slices change to varying shades of the selected color. To change how to make pie graphs on excel background color of the pie chart, go to the Chart Tools Format tab. Select Shape Fill.
To add a gradient to the background color, select Shape Fill. Select Gradient. Choose a gradient style. To change the color of the text in the title and data labels, select the Text Fill dropdown arrow. When you want to add emphasis to a slice of the how to do a fish tale, drag or explode the slice from the rest of the pie.
After a slide is exploded, the rest of the pie chart shrinks so that the chart area stays the same size. Resizing a chart may move the data labels outside the pie slices. Drag a data label to reposition it inside a slice. To explode a slice of a pie chart:.
Select a slice of the pie chart to surround the slice with small blue highlight dots. Drag the slice away from the pie chart to explode it. To reposition a data label, select the data label to select all data labels. Select the data label you want to move and drag it to the desired location. Actively scan device characteristics for identification. Use precise geolocation data. Select personalised content. Create a personalised content profile. Measure ad performance.
Select basic ads. Create a personalised ads profile. Select personalised ads. Apply market research to generate audience insights. Measure content performance. Develop and improve products. List of Partners vendors. Ted French. Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.
Updated on January 24, Tweet Share Email. After adding a pie chart, you can add a chart title, add data labels, and change colors. Was this page helpful? Thanks for how to perform the indicated operation us know! Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. Tell us why! More from Lifewire. How to Create a Column Chart in Excel. How to Create a Graph in Excel for iPad.
How to Use Charts and Graphs in Excel. How to Create a Scatter Plot in Excel. Your Privacy Rights. To change or withdraw your consent choices for Lifewire. At any time, you can update your settings through the "EU Privacy" link at the bottom of any page. These choices will be signaled globally to our partners and will not affect browsing data.
We and our partners process data to: Actively scan device characteristics how to make pie graphs on excel identification. I Accept Show Purposes.
Pick your program
In the Charts group, click Insert Pie or Doughnut Chart: If you forget which button is which, hover over each one, and Excel will tell you which type of chart it . Once you have the data in place, below are the steps to create a Pie chart in Excel: Select the entire dataset Click the Insert tab. In the Charts group, click on the ‘Insert Pie or Doughnut Chart’ icon. To make a pie chart, follow these steps: Select the range of the data you want to visualize. Click on the Insert tab from the ribbon. From the chart group, click on Insert Pie or Doughnut Chart.
Pie charts can show a lot of information in a small amount of space. They primarily show how different values add up to a whole. Got a different version? No problem, you can still follow the exact same steps. If not, though, here are a few reasons you should consider it:. Many charts specialize in showing one thing, like the value of a category. Pie charts are great for showing both a value and a proportion for each category.
The way in which data is presented by a pie chart makes it very easy to make comparisons quickly. That allows viewers to analyze the data in a snap. A box plot, for example, might leave audiences scratching their heads.
But nearly everyone knows how to read a pie chart. That makes it easier for you to present and for them to interpret.
There are many different kinds of pie charts, and they each have distinct visual advantages. For example, if you have multiple values per category, a clustered column or bar chart will better serve your purposes. And if you want to show change over time, a line chart is probably your best bet. Just make sure that your categories and associated values are each on separate lines :.
Excel can interpret both formats. Then click to the Insert tab on the Ribbon. If you forget which button is which, hover over each one, and Excel will tell you which type of chart it is. When you first create a pie chart, Excel will use the default colors and design. Mouse over them to see a preview:. One of the ways you can customize your chart is by picking a new color scheme.
Use the Change Colors dropdown to select a new one:. To change the colors and styles of individual elements, head to the Format tab in the Chart Tools section of the Ribbon:. You can also change the layout with the Quick Layout menu. The presets in this menu have elements like percentage labels, value labels, and differently located legends:. You can also add and remove individual elements with the Add Chart Element menu.
Just deselect them to make them disappear. If you selected the wrong data for your pie chart, or you added new data to your spreadsheet, you can adjust the selection with the Select Data dialog, accessed from the Ribbon:.
You can type in the Chart data range box or simply click-and-drag to identify the new selection. The pie chart is commonly used, and for good reason. It presents data efficiently, shows both values and proportions, and is very easy to read. One last step: just let us know where should we should send it. In Just 2 Minutes! The pie chart is one of the most commonly used charts in Excel.
Kasper Langmann , Co-founder of Spreadsheeto. Table of Contents. If not, though, here are a few reasons you should consider it: 1. It can show a lot of information at once. That makes for a more efficient chart. It allows for immediate analysis. It requires little additional explanation.
Variations give you more options. You can follow along with the rest of the article by using the same data we do! Getting your data ready for a pie chart is simple. Once your data is formatted, making a pie chart only takes a couple clicks. First, highlight the data you want in the chart:. In the resulting menu, click 2D Pie :. But if you want to customize your chart to your own liking, you have plenty of options. The easiest way to get an entirely new look is with chart styles.
Click on an element in the chart and use the tools in the menu to change the styles. Start today!