Pie Chart Only Includes Up to 9 Values

**teylyn** · 08-02-2016, 08:44 PM

Excel does not have a limit for the number of points in a pie chart. Unfortunately.

**Cloud909** · 08-06-2016, 07:45 PM

Originally Posted by teylyn

Excel does not have a limit for the number of points in a pie chart. Unfortunately.

Did you mean that they do have a limit? If they do not have a limit, then why can I not only include up to 9 data values in my pie chart?

**teylyn** · 08-06-2016, 09:55 PM

I don't know your circumstances, so I can't answer that question. If you post the file with the data where you can't have more than 9 data points in a pie, I could take a look. I still don't think that pie charts with that many data points are a good idea. Use a horizontal bar chart instead and sort by value.

A pie chart with 18 data points is posible in Excel, but it is a horrible user experience and I would not want to punish anyone with such a bad design. See here

**Cloud909** · 08-07-2016, 12:14 PM

Originally Posted by teylyn

I don't know your circumstances, so I can't answer that question. If you post the file with the data where you can't have more than 9 data points in a pie, I could take a look. I still don't think that pie charts with that many data points are a good idea. Use a horizontal bar chart instead and sort by value.

A pie chart with 18 data points is posible in Excel, but it is a horrible user experience and I would not want to punish anyone with such a bad design. See here

I have attached a sample of what I am doing. I tried doing a bar chart, but rather than putting 1 next to 2, 1 would be next to 5,
2 would be next to 5, and so on. I think it has something to do with excel wanting to split the data up into series 1 and series 2
but I do not want that.

Having listened to some of the other comments, I agree that a pie chart is probably not the best chart to go with in this case.

Any suggestions on how to format this data into a chart are welcomed.