Pie chart data series

RodneyC

Board Regular
Joined
Nov 4, 2021
Messages
80
Office Version
  1. 365
Platform
  1. Windows
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?

Thanks in advance
 

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
Joined
Dec 1, 2021
Messages
31
Office Version
  1. 2003 or older
Platform
  1. Windows
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
Joined
Nov 4, 2021
Messages
80
Office Version
  1. 365
Platform
  1. Windows
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.
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top