Plotting a time graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i've the following type of data that i want to plot:
Time A B C D
00:00 1 0 0 0
02:30 0 0 1 0
06:00 0 1 0 0
11:00 1 0 0 0
13:30 0 0 0 1
where A happens from 00:00 to 02:30, C happens from 02:30 to 06:00, and so
on. The time intervals need not be regular. Is there a way to plot the
happenings of A,B,C,D along a horizontal timeline using Excel?
 
You have to transform your data to something like this:

(Duration)
A 02:30
C 03:30
B 05:00
A 02:30
D ....

Select the data, and create a stacked bar chart, with series in rows. You will get a
bar for A from 0 to 2:30, for B from 2:30 to 6:00, etc. The second A is a distinct
series from the first, but you can manually format them to look the same.

To make formatting of the time axis easier, ignore the decimal fractions that Excel
expects in the scale parameter input boxes. Instead enter the values you want in
hh:mm format. Enter 0 for minimum, 24:00 for maximum, 2:00 for a two hour tick spacing.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top