ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel 2000 - Pie Chart # of slices (https://www.excelbanter.com/charts-charting-excel/116707-excel-2000-pie-chart-slices.html)

Bob

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.

Andy Pope

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

Bob

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


Andy Pope

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