# My pie chart doesn't show correct percentages

Options

I have a chart and created a summary sheet. Then I have a report based on the summary sheets. These are all shown on my dashboard. All numbers and configured correctly. I have a total of 2759 lines and 1412 are complete. I can create a pie chart base on this information but if I choose percentage the percent is incorrect. It is saying that 1412 is 34% of 2759 which is incorrect. It is 51%. What am I missing?

• ✭✭✭
Options

Yes, there is! In your report you are using the total articles and the completed articles for the pie chart. You should use completed articles and not-completed articles in the report for the pie chart.

Your non completed articles should always be (total-completed).

Below I used:

```Completed = 5
Not Completed = 10
Total = 15
```

Best,

Lidiya Shutaya

• ✭✭✭
Options

Hope your Friday is going well!

I've had this issue before and it's because the pie chart is looking at the values cumulatively not 1412 out of 2759

but

```1412 out of 4171 (2759+1412). Which is = 34%
```

If you can I would just change the Total Articles to Total Incomplete Articles.

Hope this helps!

Lidiya Shutaya

• Options

So if I want the total to be 2759 and it to show we are half complete with 1412 done, is there a way to do that?

• ✭✭✭
Options

Yes, there is! In your report you are using the total articles and the completed articles for the pie chart. You should use completed articles and not-completed articles in the report for the pie chart.

Your non completed articles should always be (total-completed).

Below I used:

```Completed = 5
Not Completed = 10
Total = 15
```

Best,

Lidiya Shutaya

• Options

You are fantastic! Thank you so much!

• ✭✭
Options

My pie chart doesn't show correct percentages

• Employee
Options

Hi @gampong

Are you displaying the Amount of the cells you're referencing or the Percentage of those values? It would be helpful to see a screen capture on this part of your chart:

You'll want to ensure "Percentage (%)" is set as the Value label.

Cheers,

Genevieve