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
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