Grouping Series Labels in a Pie Chart

R

richardstan

Hi,

I have a bank statement that looks a little like this:
ATM - £10
POS - £30
ATM - £10
ATM - £10
POS - £20

is there any way to generate a pie chart that will automatically group
series with the same name, in this case, producing a pie chart with a value
of 30 for ATM and 50 for POS. When i try to do this in excel, it creates a
chart with a different segment for each value.
Thanks
Richard.
 
A

Andy Pope

Hi,

No the chart will not do it. You can use formula, SUMIF, to do it and then
chart the data.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
Pie chart with hatch marks (black and white) 1
Doughnut Chart linked with the slicer in the pivot table 0
Pie chart-remove series w/out changing percent in pie 1
Make a mekko chart in Excel 2007 in three easy Steps 1
Pie of Pie Chart type with smaller pie showing slices of main slic 2
pie chart areas reflect magnitude 5
Pie chart labels (Office 2007) 6

Top