LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Summing graphs without differnt independent variables

Hey all,

I am having a very inconvinient problem, which seems to potentially ruin
several weeks of hard work -- and it would be immensly appreciated if anyone
could come up with a quicly implementable solution.

OK, the data I am trying to present is power demand for trains on a distance
of rail over time. In the data I have, power demand is measured at every 250
metres for each train. This means taht my data is like this.

m T1 T2 . . .
0 1500 5462 . . .
250 1700 1654 . . .
500 1200 6542 . . .
750 4000 1224 . . .
1000 3100 5555 . . .
..
..
..

Where at each cell (each 250 m) I know the power demand. Additionally, I
know at what time the trains passed each 250-metre point.

Therefore, with graph with a X-Y Scatter Chart, I can graph Power as a
function of time even though time is not an independent variable.

However, I have problems graphing the aggregate power demand as a function
of time.

Is there anyway I can sum alle the graphs in one chart, or anything similar?
Thanks in advance
 
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
charting independent XYScatter graphs mb Charts and Charting in Excel 5 May 27th 08 08:52 PM
2-4 stacked bar graphs, two variables each, Y's vary same chart Writer on Path Charts and Charting in Excel 1 October 22nd 07 08:11 PM
how to look up values with two independent variables charlesfung Excel Worksheet Functions 4 June 17th 06 03:32 PM
Variables and graphs teepee Excel Discussion (Misc queries) 7 January 2nd 06 11:47 PM
summing cells with variables jeff Excel Discussion (Misc queries) 5 March 3rd 05 07:25 PM


All times are GMT +1. The time now is 09:30 PM.

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

About Us

"It's about Microsoft Excel"