View Single Post
  #6  
Old April 21st, 2010, 04:08 PM posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
mj
external usenet poster
 
Posts: 258
Default Charting the Sum of Two, or More, Series of Data

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.

--

MJ


"MJ" wrote:

I know there must be a relatively simple solution to my challenge, short of
creating a new series od data which is the sum of desired series.

Let's say that I have the following

02/13/2010 02/20/2010 02/27/2010 ...
0-30 $7,072,987 $5,990,448 $8,978,002
31-60 177,472 160,460 142,547
61-90 24,976 25,644 2,413

Rather than tracking two series (0-30 and 31-60) as two separate series on
my graph, I would like to track a NEW series called 0-60 which is the sum of
these two series:

02/13/2010 02/20/2010 02/27/2010 ...
0-60 $7,250,459 $6,150,950 $9,120,549
61-90 24,976 25,644 2,413

So how can I do this simply within the chart, without needing to do all of
the summation separately?

--

MJ