Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Charting the Sum of Two, or More, Series of Data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line charting the same series using data from multiple sheets? | Excel Discussion (Misc queries) | |||
Charting the Sum of Two, or More, Series of Data | Charts and Charting in Excel | |||
Help with Charting Data Series | Charts and Charting in Excel | |||
Charting Time Series Data | Charts and Charting in Excel | |||
Including data in data table but not charting as a series or point | Charts and Charting in Excel |