Creating Pie Charts Without Percentages: A Comprehensive Guide

In data visualization, pie charts are a common choice for showing proportions. However, sometimes it is necessary or preferred to create a pie chart without displaying the percentages. This article will guide you through the process of creating a pie chart without percentages using various tools, including Microsoft Excel, Google Sheets, Python with Matplotlib, and online chart makers.

How to Create a Pie Chart Without Percentages in Common Tools

1. Microsoft Excel

Data preparation is the first step in creating a pie chart in Excel. Enter your categories and corresponding values into two columns.

Input your data (e.g., categories in column A, values in column B). Create the pie chart: Select the data range. Navigate to the Insert tab. Click on Pie Chart and choose a preferred style. Remove percentages: Select the pie chart to activate it. Click on the data labels. Delete the labels (or right-click and select Add Data Labels, then delete them). Customize the chart: Use the chart’s formatting tools to adjust colors, labels, and other options as needed.

2. Google Sheets

To create a pie chart in Google Sheets:

Input your data (e.g., categories in column A, values in column B). Create the pie chart: Select the data range. Click on the Insert drop-down menu. Select Chart. In the Chart editor, under Chart type, select Pie chart. Remove percentages: In the Chart editor, go to the Customize tab. Select Pie chart and uncheck Slice label to hide the percentages or other labels. Customize the chart: Adjust colors and other settings to your preference.

3. Python with Matplotlib

Create a pie chart without percentages using Python's Matplotlib library. This method requires some programming knowledge. Here's a basic example:

import  as plt# Sample datasizes  [15, 30, 45, 10]labels  ['A', 'B', 'C', 'D']# Create pie chartplt.pie(sizes, labelslabels, startangle90)# Equal aspect ratio ensures that pie is drawn as a circle('equal')# Show the plot()

Note that in this example, no percentages are shown. You can customize the appearance further based on your preferences.

4. Online Chart Makers

For those who prefer a more visual and no-code approach, various online chart makers such as Canva, ChartGo, etc., allow you to input your data and customize the chart to exclude percentages. Simply input your data and follow the tool's instructions to create a percentage-less pie chart.

Conclusion

Creating a pie chart without percentages is a straightforward process depending on your tool of choice. Whether you prefer a graphical user interface like Excel or Google Sheets, or you enjoy the flexibility of coding with Python, you can easily tailor your pie chart to meet your needs. Follow these steps to create a clear and effective visualization of your data.