And there you have it! A pie chart will appear with the data and labels you've highlighted. For our purposes, let's click on the first image of a 2-dimensional pie chart.Ĥ. You'll see a few pie options here, including 2-dimensional and 3-dimensional.
Now, click "Insert" and then click on the "Pie" logo at the top of excel.ģ. Then, highlight the data you want to display in pie chart form.Ģ.
#PROCESS TO MAKE A PIE CHART IN EXCEL FREE#
Feel free to label each column of data - excel will use those labels as titles for your pie chart.
#PROCESS TO MAKE A PIE CHART IN EXCEL HOW TO#
Plus, how to rotate a pie chart in excel, explode a pie chart, and even how to create a 3-dimensional version. Here, let's dive into how you can create your own excel pie chart for impressive marketing reports and presentations. The question was an undeniably important one, as it would influence what types of content we wrote in 2021, along with identifying new opportunities for growth.īut once I'd compiled all relevant data, I was stuck - How could I easily create a pie chart to showcase my results?įortunately, I've since figured it out. You may also want to adjust the font color to white for readability.įinally, if you want to call attention to just one segment of the pie, you may want to flatten the color scheme, then make that segment a different color.At the beginning of 2021, I was tasked with an assignment: Create a pie chart showcasing which types of content performed best on the Marketing Blog in 2020. Just click once to select all labels, then again to select a single label and move as you like. Things are looking pretty good, but there's still a few changes we may want to consider.įirst, we might want to move the legend to the top.Īnd in this case, since we do have a small number of categories, we can also move data labels to the inside of the pie.Įxcel will try to put the labels in a good location, but you can always adjust each label individually. Just double click a data label, then uncheck value and check percentage. Because the data shows a part-to-whole relationship - in other words, everything adds up to 100% - we can tell Excel to show a percentage instead of just the number. To start off, I'll resize the chart and bump up the text size. I'll use Insert, then select the pie chart option.Excel builds the chart.Īs always there're some things here we want to change. I'll leave the data for now, and lock the reference inside SUM so I can sort the categories later if I want without any problems. Now I'll just use the SUM function to gather up the rest of the data in the "other" category. We want a small number of categories so I'm going to insert 2 rows after Safari, then add a new category called "Other". Just select and copy the data, then use Paste Special with Transpose. The horizontal layout of this data is kind of awkward so let's transpose the data to a vertical format first. Pie charts show a "part to whole" relationship, and they work best with a limited number of categories. Let's build a pie chart to plot this data. Here we have data that shows market share for desktop browsers in 2016. In this video, we'll look at how to create a pie chart in Excel.
0 kommentar(er)
