ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Running Activity Chart (https://www.excelbanter.com/charts-charting-excel/99224-running-activity-chart.html)

asaylor

Running Activity Chart
 
I have 18 machines running during the course of the day. I would like to
create a chart with 1 - 18 on the y-axis and a horizontal bar or line
corresponding to the times during the day that the machine was active with
time (0:00 - 23:45) on the x-axis. I have the data for the time broken into
a "start time" column and and "stop time" column with the corresponding
machine number in a third column:

MACHINE START STOP
2 0:27 1:30
2 1:32 1:49
2 1:57 2:40
2 2:57 3:25
2 3:45 4:28
2 4:55 5:12
2 5:16 5:32
2 5:41 5:46

Thank you in advance for the help.



All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com