# Is this too complicated for pie charts?

#### Joshua McNichols

##### New Member
Hello, I would like to create 8 pie charts based on the data below. Each pie chart would indicate the percentage of each 00:27:30 segment that was devoted to certain categories of radio. Pie charts on the left would measure, for ecah segment, how much International, National and Local content we aried. Pie charts on the right would measure, for each segment, how much News, Information and Non-news we aired. There are four segments in total for this program.

Is this simply too complicated to do?
The way I see it, I need the chart to calculate based on several "IF" scenarios. It must check to see if content comes from the correct segment before deciding whether to include it in the pie chart. It must divide a time by a time to get a percentage, which is a number formatting challenge. And finally, it must collate/combine the instances of each value, so that for example all the National stories are combined into one slice of pie.

Thank you so much!

I don't expect this is something you can explain simply in a forum. But I'd like to at least understand whether I am asking too much of excel. Here are the chart cells I'm converting to a pie chart:
 Column B Column C Column D Column E Column F (h:mm:ss) 1 ATC NEWSCAST NAT NEWS 0:05:00 1 30 Second Break 0:00:30 1 (MUST BE INTERNATIONAL) TAKEAWAY OR BBC NEWS INT NEWS 0:00:00 1 30 second break 0:00:30 1 Weekday NEWS LOC NEWS 0:00:00 1 30 second break 0:00:30 1 Jack Abramoff, Reformer NAT INFO 0:06:46 1 30 second break 0:00:30 1 Canadian Mother Reunited With Children Years After Father Took Kids And Ran To Mexico INT NONEWS 0:06:31 1 30 second break 0:00:30 2 ATC Newscast NAT NEWS 0:04:15 2 30 second break 0:00:30 2 LOCAL NEWS LOC NEWS 0:00:00 2 Arkansas Oil Pipeline Spill NAT NEWS 0:03:46 2 30 Second Break 0:00:30 2 Steve Nallon, Famous For His Impression Of Margaret Thatcher, Reflects On What Made Her So Worthy Of Satire INT INFO 0:03:19 2 30 second break 0:00:30 2 David And Kristen Finch On Asperger Diagnosis NAT NONEWS 0:07:39 2 30 second break 0:00:30 2 30 Second Break 0:00:30 3 ATC Newscast NAT NEWS 0:05:00 3 BBC NEWS INT NEWS 0:00:00 3 30 second break 0:00:30 3 TAVIS News Segment NAT NEWS 0:00:00 3 30 second break 0:00:30 3 LOCAL NEWS LOC NEWS 0:00:00 3 30 second break 0:00:30 3 A Family Unmade and Made Again NAT NONEWS 0:09:42 3 1 Minute Break 0:01:00 4 ATC Newscast NAT NEWS 0:03:45 4 30 second break 0:00:30 4 The Gum Scraper Of Mexico INT INFO 0:05:42 4 30 second break 0:00:30 4 CONVO - NEWS LOC NEWS 0:00:00 4 30 second break 0:00:30 4 TAKEAWAY, TAVIS OR AS IT HAPPENS NEWS NEWS 0:00:00 4 Takeaway NEWS NAT NEWS 0:00:21 4 30 second break 0:00:30 4 Writers Almanac (NON NEWS) NAT NONEWS 0:05:00 4 30 second break 0:00:30

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

Replies
1
Views
324
Replies
3
Views
300
Replies
11
Views
342
Replies
2
Views
368
Replies
0
Views
228

1,203,528
Messages
6,055,928
Members
444,835
Latest member

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

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