Excel 2000 - Pie Chart # of slices

[Bob]

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]

Hi,

There are limits but it's not 10.

What data do you have in those 10 cells?

Cheers
Andy

 

[Bob]

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]

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