Pie Chart Maker

Paste labels and values from a spreadsheet, make an accurate pie or doughnut chart, then download PNG or SVG or print a black-and-white copy.

Last updatedHow we build & check our tools
Advertisement
Advertisement

How pie chart percentages and angles are calculated

A pie chart only works when every slice is measured against the same real total. Imagine a class survey with 24 votes for reading, 18 for games, and 8 for drawing. The total is 50. Reading takes 24 / 50 = 48% of the circle, so its angle is 24 / 50 x 360 = 172.8 degrees. Games takes 129.6 degrees and drawing takes 57.6 degrees. Add the three angles and you get exactly 360 degrees: one complete circle.

This tool applies that value / total x 360 rule to every positive row after validation and optional grouping. Sorting changes where a slice appears, not its size. Switching from pie to doughnut removes the middle of the drawing, not part of the data, so the angles stay identical. Pulling out a slice changes only its position.

Displayed percentages need one extra step. Three equal values have raw shares of 33.333...%. Showing each as 33.3% would make the labels add to 99.9%. The tool first rounds down to tenths, then gives the remaining tenth to the slice with the largest discarded fraction. The labels become 33.4%, 33.3%, and 33.3%. They add to 100.0%, while the slice geometry still comes from the original one-third values.

Open the arithmetic table under your chart when students need to show their working. It prints each value, the real total, the displayed percentage, and the exact angle rule side by side.

Moving cleanly from a spreadsheet to a chart

The fastest route from a class tally to a finished chart is two spreadsheet columns. Put the category name in the first column and its value in the second. Select both columns together, copy, and paste. Excel, Google Sheets, Numbers, and most gradebook exports place a tab between copied cells, so the labels and values arrive in the correct rows without retyping.

  • Headers are safe: a first row labelled Category and Count, or Label and Value, is recognised and left out of the chart.
  • Comma-separated files are safe: standard CSV quotes preserve a label such as "Books, paper" as one category instead of two.
  • Thousands separators are accepted: 1,250 is read as one thousand two hundred and fifty, whether it arrives in a tab-separated cell or standard CSV.
  • Blank rows are ignored: they do not become empty legend entries.
  • Questionable rows stay visible: missing labels, missing values, negative numbers, and text values are marked in the editable table so you can correct them. They are never silently changed into zero.

After pasting, read the Data check before exporting. A zero value is not an error, but it produces a 0-degree slice and is therefore omitted from the drawing. Negative values need a different chart type because a pie chart represents non-negative parts of one whole.

Choosing a pie, doughnut, exploded slice, or Other group

A pie chart is strongest when the question is about parts of one whole: how a class voted, how a day was divided, or how many books came from each genre. Five slices are easy to scan. Twenty narrow slices are mathematically valid but force the reader to work through the legend, so the Other option can make the main pattern clearer.

  • Keep entered order when the categories already follow a meaningful sequence, such as stages in a project or age bands.
  • Sort largest to smallest when the lesson is comparison. The biggest contribution becomes obvious, and nearby slices are easier to judge.
  • Group below a threshold when several tiny categories are not individually important. At 5%, every row smaller than one twentieth of the real total joins Other. The combined slice uses their exact sum.
  • Use a doughnut when the open centre helps the chart breathe beside other worksheet content. It does not change the numbers or angles.
  • Explode one slice only when there is a reason to call attention to it. Pulling a slice away can make it feel more important, but it does not make the value larger.

If every individual category matters and there are more than about ten, consider keeping the full legend or using a bar chart elsewhere in the lesson. Bars give every label its own line and make close values easier to compare.

Exporting a chart that stays readable on paper

A colour chart can collapse into a row of similar grey slices on a classroom printer. This maker gives every slice more than a colour: a repeating pattern, a dark outline, a letter key, and a legend entry with the category, value, percentage, and angle. A student can match A on the circle to A in the legend even when two fills print at nearly the same shade.

  • Print for a handout or display. The shared print layout uses black on white, landscape Letter or A4 paper, and clean page isolation. Up to twelve legend entries stay with the chart. A longer legend starts on a fresh page so neither the chart nor the text is squeezed into unreadable type.
  • SVG for worksheets, posters, and documents that may be resized. SVG stores paths and text rather than a fixed pixel grid, so edges stay sharp and the file remains editable.
  • PNG for slides, online classrooms, and applications that expect a standard image. It exports on a white background at high resolution.

For the cleanest small chart, keep the legend on and let the letter keys do the labelling. Very narrow slices deliberately skip an on-slice key when it would collide with a neighbour, but their exact value and percentage remain in the legend and arithmetic table.

Frequently Asked Questions

Common questions about the Pie Chart Maker

Put labels in one column and numbers in the next, select both columns, copy, and paste into the box. Spreadsheet tabs are detected automatically. Comma-separated data works too, including quoted labels such as "Books, paper" and values with thousands separators. A Label and Value header row is recognised and skipped.
Advertisement

Sources & References

Statistical methods and formulas

Definitions and worked methods for descriptive and inferential statistics.