MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Lori DeMotts on January 28, 2002 7:05 AM

I'm creating a pie chart in Excel and am having the pie slices show the percentage of each category I enter. Each category is measured in sales dollars, and so I've entered them dollars. The problem I'm having is that the percentages are wrong! The margin of error in only off a small amount, but I need it to be exact. Is this possible?

Posted by Mark W. on January 28, 2002 7:14 AM

Provide sample data and indicate precisely your desired result [nt]

Posted by Adam S. (-nt) on January 28, 2002 9:19 AM

Could it just be a rounding error? Is the value correct to 2 decimal places? (eg 13.24%)