Forum Discussion
Excel Chart
Please I thing to make a chart for machines for visualizing daily running or stoppages time to be dynamic for 24 hours ,one machine per row, just machines number rows and 24 hours steps .as examples below .consider same machine could stop 2 or 3 times through daily . need illustrate stops of same machine horizontally in same row with different time . is that possible in excel and how shortly .
I can quite confidently state "Yes, it's possible."
But you need to be a lot more specific on what the inputs would be--what data will you be entering--and what the desired outputs are. You say you want "to visualize daily running or stoppages" but don't give much in the way of details as to what that might look like.
So a helpful way to start building this would be to show us how you're tracking this now.
Thank For reply ,i have 10 machines in factory ,i have data per shift ( 3 shifts x 8 hours daily) for every machine like when machine in breakdown for specific issue (from 11:00 pm to 1:00 am as example) and what done to fix the problem and who worked in that time . machine normally stopped per day 2 or 3 times in average 10 to 120 minutes for every time daily .
i need just visualize stoppages in horizontal steps for during 24 hours
and in vertical line machine number or machine name .
- horizontal line bar time 24 hours will appear in it 2 or 3 stoppages for example (just 2 or 3 different color like red and the rest of bar to be green .
