Chart type not available

LDewan

Hello,

I'm trying to select the pie chart, and it tells me that this chart type is not available.  Any ideas?

Mike Wilday

Can you share a screenshot of your data? It looks like your missing data. 

Paul Newcome

Check your columns. Pie Charts can only use 2 columns (Label and Number), and must have at least one label that has a number already above zero. If all amounts are zero, there is nothing to show on a Pie Chart, therefore it will not be an available option.

Mike Wilday

Did that work for you? 

KTA

Not sure about the original requester, but it helped me.

Thanks!

TristanS

What if I want to show a pie chart of projects by US region? i.e. we have a list of projects (column), the projects have a region (location) assigned to them (column), I want to calculate the percentage of projects for each region (total 100%). How do I do that? There is not a number value to calculate the percentage, but I should be able to take the number of projects for each region and calculate a percentage of the total number of projects.

Genevieve P.

Hi @TristanS

What I would do in this instance is create a Row Report from this sheet.

Then you can GROUP by the Region, and use the SUMMARIZE function to Count how many rows are in each Region. Once you have a Grouping and Summary row in your Report, you can use this Report as the source for your Chart. A Pie Chart will automatically create percentages out of those numbers.

Here's a webinar that goes through these features: Redesigned Reports with Grouping and Summary Functions

Cheers!

Genevieve