Combine data rows in Pie Chart


    Sponsored Links


  • 1. Change insidewidth property
    hi i need to change the insidewidth property in plot area what size i want. for ex. if i am giving chatarea.plotare.insidewidth = 200 then it shows error because insidewidth is read only double. so how to change that value
  • 2. bar graph: how do you insert a break in scale (squigglly line)?
    With a wide data range or one number that is much larger than others in a series, how can one insert a break in the scale, often represented by 2 squiggly lines? Thanks!
  • 3. values in Y axis changes to percentage
    Why do the dollar values change to a percetage when I change the char type from a clustered column chart to a Stacked Column chart

Combine data rows in Pie Chart

Postby Jayntree » Fri, 17 Mar 2006 02:20:40 GMT

I have a large excel spreadsheet that has client names and transaction
amounts on it (along with other data).  I made a chart that has the
names and amount percentages on it, but there is a problem.  It lists
every transaction from a client as a different piece of the pie.  So if
a client has 5 transactions he has 5 pieces of the pie.  Any way I can
get Excel to recognize the same name and group it on a pie chart?

Jayntree's Profile:  http://www.**--****.com/ 
View this thread:  http://www.**--****.com/ 

Re: Combine data rows in Pie Chart

Postby Andy Pope » Fri, 17 Mar 2006 18:15:37 GMT


You need to summarize the data with formula or pivot table, the chart 
will not do it for you.



Andy Pope, Microsoft MVP - Excel

Similar Threads:

1.How to combine a Bar of pie and a Pie of Pie in one chart

I have a requirement to have a Bar of Pie and a Pie of Pie in one

Assuming there are two slices in the main pie chart I want to explode
one slice as a Pie of Pie and the other slice to be exploded as a bar
of pie.

Is this possible please suggest a solution I am planning to use this
for depicting a profitability analysis statement.


2.Combining Data on a pie chart

I have a data range that I am charting to show percentage of total of the 
various data categories.  The problem is there are a lot of categories under 
2% I wish to combine into 1 entitled 'Misc'  

Does anyone know a way to combine several data points into one.

TIA - Mark

3.Rows of data, using status columns to sort data to pie chart on another worksheet tab

Hi there,

1.  I have 50 rows of data.  There are many columns, but, there is one
status column that I use to group the rows of data into
relationships.   I would like to build individual charts based on the
status column.  So, if I say these items are part of "Group A",
information from those rows that are "Group A" will automatically show
up on a chart on the "Group A" worksheet tab pie chart.  I will have
"Group A", "Group B", "Group C" pie charts on seperate worksheet
tabs.  Now, I want to move an item from "Group A" to "Group C". So, in
the status column I change "Group A" to Group C".  So now it
automatically moves off the "Group A" pie chart to the "Group C" pie

2.  Also, beside the "Group C" chart, I would to list a summary of the
data (in text format) of all the rows that are part of the "Group C"
status.  If I move the data to a "Group B" status, excel moves the
data to the "Group B" pie chart and summary list.

Phew! Was this too much for one post?? :)


4.Pie of pie chart with 2 data series


I am trying to process the results from a survey. For a particular question, 
the surveyed people can answer with (say) yes, no or partially. They also 
can justify their answer, with (say) something like cheaper, simpler or 
don't know. I would like to have a pie chart with the yes, no and partially 
answers to see how many have responded with each choice, but then also a pie 
of pie chart with for the yes answers (for example) the distribution of the 

Here's what I have done so far (this is just a proof of concept with a very 
small data set). The headings yes/no/partially/justification are in B1:E1. 
Then in B2:E10, I have the answers. In the B to D column, there is a 1 when 
this was the chosen answer (and blank for the other two) and in the E 
column, there is the actual justification (cheaper/simpler/don't know). I 
have summed up the responses in B11:D11.

Then to count how many have justified their yes answer by simpler, cheaper 
or don't know, I am using DCOUNTA. So I have copied the headings in B13:E13, 
B16:E16 and B19:E19. B14, B17 and B20 are all equal to one, while E14 is 
"simpler", E17 is "cheaper" and E20 is "don't know". Finally, I have the 
following formulae in F13, F16 and F19:
F13: =DCOUNTA($B$1:$E$10,$B$1,B13:E14)
F16: =DCOUNTA($B$1:$E$10,$B$1,B16:E17)
F19: =DCOUNTA($B$1:$E$10,$B$1,B19:E20)

and that gives me the right answers, i.e. how many people have responded yes 
because it was cheaper, how many have responded yes because it was simpler, 
etc... My problem now is to create the pie of pie chart. The chart template 
in Excel doesn't allow you to have a different data set for the sub-pie 
chart. Does anybody know how to do this or can maybe suggest a better way of 
doing this? I hope I was clear enough about what I was trying to do. I can 
send you the actual Excel spreadsheet if that makes it any easier.

Many thanks in advance,


5.Pie of Pie Chart - Correct input of data

I am trying to put together a pie of pie chart, but I 
can't seem to figure out the order in which I need to 
input the data so that the smaller pie depicts the slice 
of the big pie that I want it to. I keep getting 
an "Other" slice, and have no idea where it's coming 
from. Anyone?

6. Pie In Pie Chart Data Label Issue

7. Pie of pie charts - how to set up data

8. change %s of second pie in a pie of pie chart

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 69 guest