Follow the simple steps below to do this.
Read More: How to Edit a Cell in Excel without Double Clicking (3 Easy Ways)īesides, you can also change the font of a pie chart.
For example, if we choose the Blue, accent 5 as the background color, the result will look like this. Therefore, you can change the background of a pie chart as you want. Besides, you can also change the background as Gradient fill, Picture or texture fill, Pattern fill etc.Subsequently, go to the Chart Options menu > Fill & Line icon > Fill group > Solid fill option > Fill Color icon > choose any color you want as the background.This will create a new ribbon named Format Chart Area at the right side of the Excel file. First and foremost, double-click on your pie chart area.You can also edit the background color of a pie chart in Excel. And, the result will look like this if we choose the second option from the Colorful list. Therefore, you will see that you have made edits in your pie chart color successfully according to your choice. At this time, choose any color you want for your pie chart. Subsequently, click on the Change Colors tool. Secondly, go to the Chart Design tab from the ribbon.This will add two tabs named Chart Design and Format in the ribbon. First and foremost, click on your pie chart.You can change the default chart color of a pie chart. I have shown you 11 types of edits of a pie chart below. Now, regarding the modification of the pie chart, there can be edits on many aspects. According to this dataset, we also have a pie chart representing the sales per weekday. Say, we have a dataset of a store’s sales per weekday. Legend: These are the unique specifications marked for differentiating each category from each other and for easy understanding.Data Label: These are the values of the categories.From this title, one can understand what the chart is about. Chart Title: This is the title of the chart.In a pie chart, there are three important chart elements. Each section represented in the chart is called a Category and each value associated with those categories is called a Value. It is of great use to visualize the weights of the individual data of a dataset. We can see this by hovering over the wedge.A pie chart is a useful tool to represent statistical data in a circular chart form. If they didn’t add up to 100%, then the wedges of the pie chart would be different than the percentages listed.īecause our list of percentages added up to 100%, the blue wedge that represents that 30% of the population like the color blue is also 30% of the pie chart. This list of percentages add up to 100%, so our pie chart is an accurate representation of the percentages. We can see this percentage by hovering over a wedge in the chart. Since we have 20 pears, the orange wedge is 20/50=40% of the whole pie chart. Since our list of fruits add up to 50, the wedges are the percentage calculated as the number divided by 50. Notice that the pie wedges are not a representation of the numbers in the column, but the percentage of the total. You can also edit the appearance of the chart using the menu bar at the top or by double-clicking on different parts of the chart. You can adjust the size by pushing and pulling on the sides of the chart. Then select PIEĮxcel will automatically create a pie chart for you. Step 3: In Excel, go to INSERT in the menu. If you want to have the labels on the chart, you need to highlight the labels of the data as well. Notice that the total percentage adds up to 100%. Here is a list of the favorite color percentages of some population of people. Notice that they add up to a total of 50. Here is a list of different fruits and the number of each. The pie chart will be a representation of the percentages of the data total. Video Source (04:11 mins) | Transcript Step 1: Have a list of data in Excel