Collumn chart: Variable usage over time

Hi,

I would like to create a collumn chart where I can see how much of the total time, in percent, was used for each variable. E.g. the variable A starts at time 00:01 and ends at 00:05 where L starts and so on.

Time Variable
00:01 A
00:05 L
00:10 A
00:22 Cp
00:32 Cp
00:41 P
00:56 L
01:14 L
01:25

I'm new to this forum so please inform me if my post is unfit in any way.

Thanks!

/Svante

First you will need to create a table on the side of that to count each varieble total time and total time available. Then on the bottom/end of each vvariable you will need to make a formula that counts percentage and this is what you base your chart on.

If don't know how to start please attach a dummy worksheet as an example.

Simon