Pie Chart showing incorrect percentage in label

I'm trying to make a Pie Chart with "Revenue," "Expenses" and "Savings" values and percentages. The problem is that the label options for "Percentage" are not showing the correct percentage as per the calculations.

Here are formulas to calculate percentage:

% Revenue = Net Income / Revenue
% Expenses = Expenses / Revenue
% Savings = Savings / Revenue

* Note that the "Net Income" formula I'm using is "Revenue - (Expenses + Savings)".

If you look at the example in the picture you see that percentage for Revenue = 45%, Expenses = 50% and Savings = 5%.

PieChart-Inco_Percentage.jpg

The results make sense regarding financial formulas. However, Excel pie chart percentage label is showing something completely different (65% Revenue, 32% Expenses and 3% Savings).

I understand that Excel pie chart calculates percentage base on the total values (in this example $310), but for I want these percentages are incorrect.

Is there a way to show the correct percentage in the pie chart? Thanks!

You should be able to select your labels from the values you have in Column C rather than the standard percentage value.

Try selecting the Series Name option and defining the range.