Home |
Search |
Today's Posts |
#1
|
|||
|
|||
quick help with graphing
okay, this is a pretty simple question. I learned how to do it once, but for the life of me, I can't figure out how to make it work. here is the problem: I have two sets of data- elapsed time(x-axis) and velocity(y-axis) on a line graph I can get it to graph, however I can't figure out how to change the scale of the x-axis (I can change the y-axis, but not the x-axis).....and I can't figure out what I am doing wrong. also, I was supposed to put the x-axis data in one column and the y-axis data in another before I set up the graph, right? any help would be appreciated as this is for a school project and I need to finish it ASAP. also, is there any way, using excel, to find the area under a line graph? -- kalilza ------------------------------------------------------------------------ kalilza's Profile: http://www.excelforum.com/member.php...o&userid=28657 View this thread: http://www.excelforum.com/showthread...hreadid=483247 |
#2
|
|||
|
|||
quick help with graphing
Are you using a Line graph or an XY graph? The x-values in a Line graph are categories, and are not necessarily "scalable." Make sure you're using an XY plot where the x-values are treated as real numbers. As for getting the area under the graph, to my knowledge Excel doesn't have that ability built into it. But Excel is certainly capable of the calculations necessary to obtain the area under the graph. Without seeing the actual data, I can't say for sure the best approach. If you know V(t) and can also come up with an anti-derivative for V(t), then you can make use of the fundamental theorom of calculus to determine the area under the curve. If you don't have V(t), but can get a reasonable V(t) using curve fitting techniques, then you can use that V(t) to get the area under the curve. If your delta-t values are small enough (small enough depends on how curved V(t) is), then you can use Riemann sums to estimate the area under the curve. Does that help? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=483247 |
#3
|
|||
|
|||
quick help with graphing
yes, it does help. thank you -- kalilza ------------------------------------------------------------------------ kalilza's Profile: http://www.excelforum.com/member.php...o&userid=28657 View this thread: http://www.excelforum.com/showthread...hreadid=483247 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing STRANGENESS - 2nd series plotting as sum of series 1 and | Charts and Charting in Excel | |||
Quick way to sort lists by text color? | Excel Discussion (Misc queries) | |||
excel quick find format | Excel Worksheet Functions | |||
quick books and excel 2002 | New Users to Excel | |||
Graphing Woze? | Excel Discussion (Misc queries) |