Plotting a time graph

K

kaifai

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?
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top