Charting the Sum of Two, or More, Series of Data
in [Functions]
|
From: MJ on 20 Apr 2010 13:06 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
From: Don Guillett on 20 Apr 2010 13:33 How about a stacked bar chart -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "MJ" <MJ(a)discussions.microsoft.com> wrote in message news:271D5A77-B7A7-498F-8D53-CF4964B6EFFD(a)microsoft.com... >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
From: MJ on 20 Apr 2010 14:43 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 > dguillett(a)gmail.com > "MJ" <MJ(a)discussions.microsoft.com> wrote in message > news:271D5A77-B7A7-498F-8D53-CF4964B6EFFD(a)microsoft.com... > >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 > > . >
From: trip_to_tokyo on 20 Apr 2010 15:00 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
From: MJ on 21 Apr 2010 10:57
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 |