Pls help. Excel graph question.

Supernova_26

New Member
Joined
Jan 16, 2014
Messages
2
Hello,
Pls don't bash me but I have reached my limits with excel I am looking for some help with some statistical help. I have 3 data columns Date of Measure/ Time of Measure/ Voltage Measurements. I have 31 days of data with samples every 2 min. The time is shown in 24hrs format. Is that a way for me to graph how long each power outage lasted each day. A power outage condition happens when voltage is less then 5 volt.

Example
Date of meas Time of meas. Voltage
12/12 23:22 110
12/12 23:24 0
12/12 23:26 0
12/12 23:28 110

So is that a way for me to graph the date 12/12 and see that I have a power outage that lasted 4 min.
Thank you so much
Toni
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
TimeVoltsIs Outage StartIs Outage
End
Duration
00:000112
00:0211000#N/A
00:040104
00:06001#N/A
00:0811000#N/A

<tbody>
</tbody>

The upper left corner is cell A1.

C2: =IF(B2, 0, 1)
C3 and copied down: =IF(AND(B3<>B2, B3=0), 1, 0)

D2 and copied down: =IF(AND(B2=0, B2<>B3), 1, 0)

E2 and copied down:=IF(C2 = 1, 2 * MATCH(1, D2:D721, 0), NA())

Plot "Duration" as a column chart using "Time" as the horizontal axis.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top