percentages in an excel pie chart

G

Guest

How do I manually enter percentages into an excel pie chart. I already have
the percentage values from a history project and now I need to enter them
into a pie chart for a visual.
 
G

Guest

You don't need to enter percentages. Just plot the data. Excel calculates the
percentages for each element relative to the sum of all data. Example:

A1 = 1 Pie chart returns: 2%
A2 = 5 Pie chart returns: 12%
A3 = 5 Pie chart returns: 12%
A4 = 5 Pie chart returns: 12%
A5 = 25 Pie chart returns: 62%

Note that Excel rounds the percentage values.

Regards,
Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Can a pie of pie chart use animation/transitions? 1
Excel 3-D Pie Chart Flaw & Test 3
Pie Chart percentage 1
Pie chart-remove series w/out changing percent in pie 1
Pie Chart - Percentage of a total? 1
Percentages in a pie chart 3
Change pie chart start point or orientation 1
Basic Categorical Pie Chart Question 2

Top