Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
percentages in an excel pie chart
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
percentages in an excel pie chart
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart disappears in Excel 2000 | Excel Discussion (Misc queries) | |||
Copying an Excel chart into a Word document | Excel Discussion (Misc queries) | |||
how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
Displaying MS Excel Chart control in ASP.NET Application | Charts and Charting in Excel | |||
Permanently visible colunm in an Excel chart | Excel Discussion (Misc queries) |