# Pie chart data series

#### RodneyC

##### Board Regular
I’m trying to create a pie chart that aside from data labels, includes data from two cells. One is a TOTAL number of the entire universe of what I’m measuring. This data is in cell D8. Currently that number is 583,948. In cell D24 is a subset of D8. Currently that number is 164,100. These numbers together total 748,047. This is not a number I want referenced in any way.

If I try and create a pie chart using those two cells D8 and D24 as the data points along with cells that include the data labels, the chart shows both numbers as making up the entire pie and my subset, D24 shows it’s 22% of the total 748,047 while D4 represents 78% of the pie. What I need is one slice of pie that shows my subset as being 28% of the entire pie (164,100 is 28% of 583,948)

Is there a way to show this?

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### LongToast

##### New Member
if you want 28% of 583,948 then don't include that 583,948 cell as data chart, if 1 + 2 = 3 you can only use 1 and 2 as data chart (that would make more sense) and not 3, as you said it's subset, why you have to include let's just call it the "total" which is 589,948 as data chart? if i were you, first i will subtract that 589,948 to 164,100, second i use that subtraction result and 164,100 as data chart.

sorry for my bad english, hope it help.

#### RodneyC

##### Board Regular
if you want 28% of 583,948 then don't include that 583,948 cell as data chart, if 1 + 2 = 3 you can only use 1 and 2 as data chart (that would make more sense) and not 3, as you said it's subset, why you have to include let's just call it the "total" which is 589,948 as data chart? if i were you, first i will subtract that 589,948 to 164,100, second i use that subtraction result and 164,100 as data chart.

sorry for my bad english, hope it help.
Thanks. This helped me figure it out. A simple rename of the data set gave me what I needed. Your advice helped.

Replies
1
Views
154
Replies
1
Views
148
Replies
1
Views
1K
Replies
2
Views
449
Replies
2
Views
56

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,110
Messages
5,768,156
Members
425,458
Latest member
Jaspal1996

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back