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
|