Don,

Had not thought about that one, but I did try it. While might be a dark
horse possibility lacking a different solution for the sum of the series
group, due to the volume ot tracking points and the size of the graph it
looses a lot in the rendering. I even looked at the stacked area and line
graphs.

This is one of those times that a single line graph is the most productive
representation.

If you, or anyone else, has a solution on how to come up with a Series
values formulas what will sum the series values, that is what I am looking
for.

Thank you for your suggestion.

--

MJ


"Don Guillett" wrote:

How about a stacked bar chart

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MJ" wrote in message
...
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

.