Forum Discussion
Excel Chart
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 .
- appreciate your help.
I'm on vacation this week, and so don't really have time to devote to your task. Perhaps somebody else could.
What you've shown us, though, makes me wonder why your very first image (of what I assume is the "raw data") isn't sufficient in itself, especially if sorted in order by machine. All of the information would then be there, and color coding (conditional formatting, automatic) could be used, to indicated whether running or shut down. One thing you'd need to add is some descriptive code; you appear to be using color right now, but don't indicate how that is applied.
So let me ask those two questions very specifically:
- How do you code or mark the status of the machine? Are there subsets--especially for when it's not running (to indicate different reasons, perhaps, such as mechanical difficulties vs manpower shortages, etc)?
- If that table could be sorted in order by machine (and time slots) would that be sufficient to meet your needs? If not, why not?
- the graph to be appeared 10 horizontal stacked bar for 10 machines . each Bar length is 24 hours (24 portions) some of portions colored red in some area illustrate machine stop times by day