I need to plot the following info:

Row A represents Car names
Row B represents the Estimated time for Arrival for the cars
Row C represents the Estimated time of Departure for the cars
Row D Represents the estimated time of how long th cars were standing still once they've reached their destination.


the object of this graph is to show the overlap in times where the 3 vehicles have remained idle on the ground.

 

Sorry dude, have to tell you this:
you're making it rather hard for people to help you.
There is no such thing in Excel as Row A, B, C......, it's numerical.

Suggest you fix your question and remove confusion.

 

it can't be that difficult to read...you've got 4 columns with information that needs to be graphed. If you copy the info into a spreadsheet you maybe able to see it better...I just want to know if it's possible to do the graph because I have been working on it since 9am this morning with no luck...and I have about 30 of these to do...

 

are you being serious or sarcastic?

 

So you basically want a line graph? Just use the graph wizard and follow the steps. Couldn't be easier. But I'm very confused, the chart you gave conflicts with what you wrote.

 

on topic.... why is there 4 "cars", but only three times?

 

At the top, there is an Insert drop down menu
Within that menu is "chart"
highlight your data and
click that.

 

serious.
I'm just very annoyed by TECHNICAL/computer questions that are badly written and posted online.
They create confusion.
Seen way too many of those I guess.

I actually understand his question....only it took me a few more brain cells to process that than otherwise.

see what I mean ?

 

I see.


anyway, so the only thing you need in the graph is ETA and ETD. You don't need to (can't) include duration, since it's just a function of ETD - ETA, and therefore unnecessary for showing what you want to show.

Just list the cars in the far left column, with the header "Cars". Then have ETA and ETD as the headers of the next two columns. list the times accordingly, highlight the table, then hit the graph button. Choose a line graph and the lines for car "B" and car "C" should overlap at a certain point.

 

The horizontal rows in an Excel spreadsheet are listed A B C D E F etc. and the vertical rows are listed 1 2 3 4 5 6 7 etc. So, if you are in the first row, first cell, you are in cell A1.

 

They're called columns

rows are numbered, columns are alphabetized in excel. you differentiate them by calling them horizontal and vertical rows?

 

You know what I mean, but yes they are called columns. I was simply pointing out that there are "columns" in an Excel spreadsheet listed alphabetically.

 

hmmmmm Horizontal rows...

fxcking einstein

 

Wow, I called it a horizontal row...that makes me such an idiot. Who gives a shit, I sure don't! Bottom line, if you weren’t such a prick, you would have never called him out on how he posted his question. You knew damn well what he meant, but you felt compelled to be a jerk about it.

 

daymmmn chill out.
So I was a prick for trying to correct him, fine.

 

What's funnier is you should have been criticizing his use of "vertical rows", as horizontal rows, though redundant, is correct

 

haha right ! oh the irony and confusion....

 

CAR ETA ETD DURATION
Car 1 4:23 7:20 2:57
Car 2 6:25 22:40 16:15
Car 3 18:55 22:28 3:33

 

suite! but that ^^^ should be graphed by rows, not columns.

 

WRONG...because it doesn't show how long the cars sit on the lot at the same time...that's the whole point of the graph...and you should try doing a stacked graph not a line. graph

 

If you know how to do it so well then FUCKING DO IT and stop criticizing the people who volunteered to help you. Fuckwit.

 

 

Huckleberry, you were right on point being a prick...I just didn't see why until 2:50pm.

 

jackass

 

 

HEY NUMB NUTS...

I know what the F***ING graph is going to look like, I wanted to know if it could be done on Excel...Now get out of this thread if you're not going to help

 

and from my graph, you can see that

ALL THREE CARS ARE NEVER ON THE LOT AT THE SAME TIME

A B C

4:23 6:25 18:55
7:20 22:40 22:28
2:57 16:15 3:33

jackass

 

this is my understanding of WTF you're trying to say:

 

oh shit!

 

This is what I had in mind. only two of the cars overlap at a time.


EDIT- I think there's a way to draw a horizontal line across to the y axis where the data points are, in case you want to shade in that area to show overlap.

 

only car B and C are on the lot at the same time unless you messed up the numbers

 

There you go...very well...now how did you do that

 

 

Blow me. Next time do your own homework. Fucking retard.

 

JC is about to crush you.

 

IT ISN'T HOMEWORK...Now you go back to school...fool

 

Fool? You're the one who's been working on this since 9 AM and haven't figured it out yet

 

it doesn't take a guru to do this in excel

 

HINT HINT...Read the title of the thread...I don't fucking use Excel everyday.

 

Why didn't you figuer this out??