Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
Charts
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?
Provide sample data and indicate precisely your desired result [nt]
Posted by Mark W. on January 28, 2002 7:14 AM
Could it just be a rounding error? Is the value correct to 2 decimal places? (eg 13.24%)
Posted by Adam S. (-nt) on January 28, 2002 9:19 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.