Damnit,

I just want to make a simple (?!) graph in Excel.

The dataset is attached.

The first column is just time, which I want shown along the bottom, and the next four columns I want used to plot a line graph (four lines) with a 0-8 scale on the vertical axis. How F(*&ING hard can this be? I hate Excel!

Anyone can help, gets supply of cookies. Or at least, the thought thereof (which is what counts).

Lemme have a go at this,

Edit: How in the name of god was my post , which is after yours, at an earlier time?

Here's about the best I can do in the time available - adding trendlines (right click the lines to remove/edit them) gives you a constant line, otherwise your dataset is a little sparse.

You don't have data from same time so that is what causes your problem probably as cell without data is read as 0. Comparision is bit hard to do with that data, perhaps some guessing needed to get table filled or interpolate values. Don't know, I'm not excel pro if there is some simpler method to get that done.

Quote from Christofire :

Here's about the best I can do in the time available - adding trendlines (right click the lines to remove/edit them) gives you a constant line, otherwise your dataset is a little sparse.

Hey thanks; that's not bad.

I had hoped excel would join the nodes to interpolate, but I guess not.

I don't even know how you got it to what you did, so thanks!

Quote from S14 DRIFT :

Edit: How in the name of god was my post , which is after yours, at an earlier time?

I'm not seeing it...

Quote from S14 DRIFT :

Edit: How in the name of god was my post , which is after yours, at an earlier time?

WFT?!

I used simple linear interpolation! Here is a zip file with my excel chart, and a PDF too!

Thanks for your help guys!