Excel 2000 - Pie Chart # of slices

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 30 Oct 2006 19:20 GMT

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.

Reply to this Message

Andy Pope - 30 Oct 2006 20:12 GMT

Hi,

There are limits but it's not 10.

What data do you have in those 10 cells?

Cheers
Andy

> 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.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Bob - 30 Oct 2006 21:16 GMT

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.

> Hi,
>
[quoted text clipped - 8 lines]
> > 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.

Reply to this Message

Andy Pope - 31 Oct 2006 20:15 GMT

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

> 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.
[quoted text clipped - 13 lines]
>>>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.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message