Is this too complicated for pie charts?

[Joshua McNichols]

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>