Pierre,
I like your approach to my problem and I was looking at a pivot tablechart
as a possibility, but would require a major restucturing of our current
report format that our leadership is not prepared for at this time. I may
yet need to lead them down that path in the future, but right now they want a
simple brute force solution.
Thank you for your efforts and I will keep it handy as an example for the
future.
--
MJ
"trip_to_tokyo" wrote:
EXCEL 2007
Hi MJ.
I have just pu up a file for you at:-
http://www.pierrefondes.com/
Item number 97.
I have created a Pivot Table and Pivot Chart from the data that you provided.
You can toggle on / off what's in the chart by using the drop down in F2.
For your 0 to 60 day period I created a Calculated Item (as you can see).
Hope this helps you out.
If my comments have helped please hit Yes.
Thanks.
"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