LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
mj mj is offline
external usenet poster
 
Posts: 78
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line charting the same series using data from multiple sheets? Aaron Excel Discussion (Misc queries) 1 April 29th 10 10:10 PM
Charting the Sum of Two, or More, Series of Data MJ Charts and Charting in Excel 6 April 22nd 10 05:06 PM
Help with Charting Data Series MJ Charts and Charting in Excel 3 July 16th 08 02:01 PM
Charting Time Series Data klbva Charts and Charting in Excel 1 November 3rd 06 05:09 PM
Including data in data table but not charting as a series or point pepper76 Charts and Charting in Excel 4 August 2nd 06 03:20 AM


All times are GMT +1. The time now is 11:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"