Excel charts chart data from Excel cells. There may be tricks using
named formulas, but these are difficult to get right and prone to
maintenance issues.

What is so terrible about putting the totals into the worksheet? You
could put them somewhere outside the print range if you don't want to
clutter up the worksheet.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/21/2010 11:08 AM, MJ wrote:
Point of clarification... our current report format tracks datasets spanning
24 months. The sample data in original questions is only a small subset.

* Due to the amount of tracked data, while the stacked barchart might work
in a fashion, it looses so much in translation that it is not viable for this
application.

What I am looking for is...

Is there a way within the 'Select Data Source', 'Series' to identify the
desired series as a resulting summation of two, or more, series WITHOUT
having to actually create such a dataset/series to reference in the data
source selection.

Someone out there has to have this answer. Thank you in advance for your
time and efforts.