nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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?

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…