Excel 2000 - Pie Chart # of slices
Is there a limit to the number of slices in an Excel 2000 pie chart. I can
only get (9) to work using the wizard. As soon as I add (10) the last one gives an error readin and it sits there incomplete. |
Excel 2000 - Pie Chart # of slices
Hi,
There are limits but it's not 10. What data do you have in those 10 cells? Cheers Andy Bob wrote: Is there a limit to the number of slices in an Excel 2000 pie chart. I can only get (9) to work using the wizard. As soon as I add (10) the last one gives an error readin and it sits there incomplete. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Excel 2000 - Pie Chart # of slices
I am just grabbing a numerical value for the size of the slice and the name
of each to label the slice. I only had 11 items to grab and could only do 9. Also I had noticed that the formula's were tough to work with manually. "Andy Pope" wrote: Hi, There are limits but it's not 10. What data do you have in those 10 cells? Cheers Andy Bob wrote: Is there a limit to the number of slices in an Excel 2000 pie chart. I can only get (9) to work using the wizard. As soon as I add (10) the last one gives an error readin and it sits there incomplete. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Excel 2000 - Pie Chart # of slices
Hi Bob,
I can not imagine what data you have that is causing you problems. If you want to email me you workbook I will take a look. Cheers Andy Bob wrote: I am just grabbing a numerical value for the size of the slice and the name of each to label the slice. I only had 11 items to grab and could only do 9. Also I had noticed that the formula's were tough to work with manually. "Andy Pope" wrote: Hi, There are limits but it's not 10. What data do you have in those 10 cells? Cheers Andy Bob wrote: Is there a limit to the number of slices in an Excel 2000 pie chart. I can only get (9) to work using the wizard. As soon as I add (10) the last one gives an error readin and it sits there incomplete. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 03:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com