Excel Tutorial: How To Make Pie Chart In Excel With Percentages

Introduction


Are you looking to create a pie chart in Excel with percentages but not sure where to start? In today's data-driven world, visualizing data is crucial for understanding and interpreting information. Pie charts are an effective way to display data, especially when it comes to showcasing percentages and proportional relationships. In this Excel tutorial, we will guide you through the step-by-step process of creating a pie chart with percentages, so you can effectively communicate your data in a visually appealing way.


Key Takeaways


  • Visualizing data with pie charts is important for understanding and interpreting information.
  • Organize and calculate the percentages for each category before creating the pie chart in Excel.
  • Customize the pie chart by editing the title, data labels, and colors to make it visually appealing.
  • Display percentages on the pie chart by adding data labels and formatting them accordingly.
  • Fine-tune the pie chart by adjusting its size, position, and adding any necessary additional details or annotations.


Step 1: Prepare the data


Before creating a pie chart with percentages in Excel, it is important to organize and calculate the data that will be used for the chart.

A. Organize the data that will be used for the pie chart

Start by organizing the data that you want to represent in the pie chart. This could be sales data, expense categories, or any other data that you want to visualize. Make sure to arrange the data in a clear and understandable manner.

B. Calculate the percentages for each category

Once the data is organized, calculate the percentages for each category. To do this, divide the value of each category by the total sum of all the values, and then multiply by 100 to get the percentage.

  • For example, if you have sales data for different products, calculate the percentage of sales for each product by dividing the sales value of each product by the total sales value, and then multiplying by 100.
  • Make sure to format the percentages to your desired decimal places.


Step 2: Insert a pie chart


After preparing your data and calculating the percentages, it's time to create a pie chart to visually represent the data.

A. Open Excel and select the data range

Begin by opening Microsoft Excel on your computer. Once the application is open, select the data range that you want to include in the pie chart. This range should include the categories and their corresponding percentages.

B. Go to the 'Insert' tab and choose 'Pie Chart'

Once the data range is selected, navigate to the 'Insert' tab at the top of the Excel window. In the Charts group, click on the 'Pie Chart' option. A drop-down menu will appear, allowing you to select the specific type of pie chart you want to create.


Step 3: Customize the pie chart


After creating the pie chart and adding the percentages, it’s time to customize the appearance and add clarity to the chart.

  • A. Edit the chart title and data labels

    Once the pie chart is created, you can double-click on the chart title to edit it and make it more descriptive. Similarly, you can also click on the data labels to edit them and display the actual values if needed.

  • B. Change the colors of the pie slices to make them visually appealing

    To change the colors of the pie slices, simply click on the pie chart to select it and then click on the "Format" tab. From there, you can choose different color options to make the chart more visually appealing and easier to interpret.

  • C. Add a legend to the chart for clarity

    Adding a legend to the pie chart can provide clarity, especially if there are multiple categories. To add a legend, click on the chart and then click on the "Add Chart Element" button. From there, select "Legend" and choose the desired position for the legend within the chart.



Step 4: Display percentages on the pie chart


Once you have created your pie chart in Excel, the next step is to display the percentages on the chart to provide a clear visual representation of the data.

A. Right-click on the pie chart and select 'Add Data Labels'


  • After selecting the pie chart, right-click on it to reveal a drop-down menu.
  • From the drop-down menu, select 'Add Data Labels' to display the data labels on the chart.

B. Format the data labels to show the percentages


  • To format the data labels to show percentages, click on any of the data labels to select them.
  • Then, right-click on the selected data label and choose 'Format Data Labels' from the menu.
  • A 'Format Data Labels' pane will appear on the right-hand side of the Excel window.
  • Within the pane, navigate to the 'Label Options' tab and check the box next to 'Percentage' to display the percentages on the data labels.
  • You can further customize the appearance of the percentages by adjusting the font, size, color, and position of the data labels.

By following these simple steps, you can easily display percentages on your pie chart in Excel, making it easier for viewers to understand the distribution of the data at a glance.


Step 5: Fine-tune the pie chart


Now that you have created your pie chart with percentages, it's time to fine-tune it to make sure it looks professional and visually appealing.

A. Adjust the size and position of the pie chart on the worksheet
  • Resize the chart:


    Click on the chart to select it, and then click and drag the sizing handles to resize the chart as needed. You can also use the Format tab under Chart Tools to specify exact dimensions.
  • Move the chart:


    Click and drag the chart to reposition it on the worksheet. Ensure that it doesn't overlap with any important data or text.

B. Add any necessary additional details or annotations to the chart
  • Add a title:


    Click on the chart to select it, and then go to the Layout tab under Chart Tools. Click on "Chart Title" and choose where you want the title to appear (above the chart, centered overlay, or none). Enter a title that clearly describes the information being displayed.
  • Add data labels:


    Data labels can be added to the chart to show the exact percentage for each segment of the pie chart. Click on the chart to select it, then go to the Design tab under Chart Tools and click on "Add Chart Element". Choose "Data Labels" and select the position where you want the labels to appear (center, inside end, outside end, etc).
  • Adjust colors and formatting:


    You can further customize the appearance of the pie chart by changing the colors of the segments, adding a legend, or adjusting the font and style of the chart elements. Use the "Format" tab under Chart Tools to make these adjustments.

By following these steps, you can ensure that your pie chart not only accurately represents the data but also looks polished and professional.


Conclusion


Creating a pie chart in Excel with percentages is a valuable skill for effectively presenting data. By following the simple steps of selecting data, inserting a pie chart, and formatting it to display percentages, you can easily create a visual representation of your data. The use of visuals like pie charts can enhance the communication of complex data sets and make it easier for your audience to understand the information you are presenting. I encourage you to practice creating your own pie charts in Excel to become proficient in this useful tool for data analysis and presentation.

Excel Dashboard

ONLY $99
ULTIMATE EXCEL DASHBOARDS BUNDLE

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles