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.
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.
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
"Alexis" wrote:
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks