Charting the Sum of Two, or More, Series of Data
in [Functions]
|
From: MJ on 21 Apr 2010 11:08 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
From: Jon Peltier on 22 Apr 2010 12:06
Excel charts chart data from Excel cells. There may be tricks using named formulas, but these are difficult to get right and prone to maintenance issues. What is so terrible about putting the totals into the worksheet? You could put them somewhere outside the print range if you don't want to clutter up the worksheet. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 4/21/2010 11:08 AM, MJ wrote: > 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. > |