Does any Chart Y-axis with 2 Values on X-axis(A train's tracking)

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

I need to draw a chart, where Y-axis represent Railway
Stations and X-axis represent times of a day.

I need to show simple line chart Stating From Station A,
0700hr(Train Dep Time);Station B 0800hr(Train arrive
time);Station B 0800hr(Train Dep Time);Station C 0830hr
(Train Arrive Time);Station C 0835hr(Train Dep Time);and
finally Station D 0900hr(Train Arrive Time).

You can see that in some station, the train does not stop
and so Arrive and Dep time are the same. But in some
stations, the train stops and therefore the line chart
will show as parallel to X axis during its stops at the
stations.
Does any chart tools support this feature?
Can any one help me?
Thanks in advance.
 
brian said:
I need to draw a chart, where Y-axis represent Railway
Stations and X-axis represent times of a day.

I need to show simple line chart Stating From Station A,
0700hr(Train Dep Time);Station B 0800hr(Train arrive
time);Station B 0800hr(Train Dep Time);Station C 0830hr
(Train Arrive Time);Station C 0835hr(Train Dep Time);and
finally Station D 0900hr(Train Arrive Time).

You can see that in some station, the train does not stop
and so Arrive and Dep time are the same. But in some
stations, the train stops and therefore the line chart
will show as parallel to X axis during its stops at the
stations.
Does any chart tools support this feature?
Click to expand...

What feature wo you want? If you want the horizontal line to show up, you
don't need to do anything special. If you *don't* want the horizontal line,
you could just put a blank cell between arrive/depart and tell Excel not to
plot blank cells. There are other possible solutions as well, depending on
what you want.

Dave
dvt at psu dot edu
 
-----Original Message-----


What feature wo you want? If you want the horizontal line to show up, you
don't need to do anything special. If you *don't* want the horizontal line,
you could just put a blank cell between arrive/depart and tell Excel not to
plot blank cells. There are other possible solutions as well, depending on
what you want.

Dave
dvt at psu dot edu


.
Click to expand...
Dear Dave,
Thanks and glad to hear that it is possible. I really
don't know what type of line chart I should use. Kindly
help me guide what to do.
My data will be
Station - Time
A - 0700
B - 0800
B - 0800
C - 0830
C - 0835
D - 0900

Only Y Axis, I want to see
A
B
C
D
-Not
A
B
B
C
C
D
I want to plot a line starting from (A,0700),
then (B,0800)
then (C,0830)
then (C,0835)
and (D,0900)

Thanks you very much for your answer.
Brian
 
Back
Top