Multiple Charts That React to Custom Excel Filters?

Fellow Forum Members,
Not sure if this is the is the proper subforum to post in or if my Keyword
title is adequate, maybe the forum admin could address these concerns.

I'm using Excel 2007 and my objective is to setup a trading log that tracks
my performance with charts that dynamically update to applied custom date
range filters. The link below shows screenshots of what I'm trying to emulate
with Excel 2007.

http://www.fxtraderlog.com/screenshots.htm

I have all my trading data laid out in a tabular format simlar to what is
shown in the top screenshot. My tabular layout differs in that it includes 4
additional columns. My chronological data layout I'm using seems to be
troublesome for conventional Excel charting methods.

When I apply custom filters for open dates and close dates, my Excel charts
do not dynamically react. What I have determined is that I need to bypass the
conventional charting methods used in Excel and focus instead on using Charts
that rely on a VBA script or a formula. My objective is to have multiple
charts (like the ones shown in the screenshots link above) all using the same
data nested in my tabular trading log.

Can anyone out there help me out with setting up Charts that are more
robust? I would appreciate example VBA scripts and / or links that will show
me how to setup charts that dynamically react to custom Excel Filters, and
can group together matching data sets in a column and show such data sets as
a single slice in a pie chart. Currently, I'm getting multiple pie slices for
the same data set. I need a formula or a VBA script that will clump together
all of the data that belongs in the same group and show it as a single slice
in a pie chart.

Any help that will help me get past these two hurdles will be greatly
appreicated. Thanks.