Forum Discussion

Ahmed_Moharam1969's avatar
Ahmed_Moharam1969
Copper Contributor
Jul 04, 2022

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 ...
excel
mathetes's avatar
mathetes
Gold Contributor
Jul 08, 2022

Ahmed_Moharam1969 

 

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:

  1. 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)?
  2. 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?
  • Ahmed_Moharam1969's avatar
    Ahmed_Moharam1969
    Copper Contributor
    Jul 09, 2022

    mathetes 

    First of All, thanks for your support and enjoy your vacation.

     please find my below respond your question.

    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)? running time white, mechanical breakdown green, electrical breakdown yellow, not planned time to run blue.

    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? This table and chart are okay in my photos but only I faced one problem couldn’t solve that If same machine stop for breakdown for second or third time come in chart in different bar below first one but I need to illustrate only one horizontal bar per machine showing different times of breakdowns happened on 24 hours.

     

    Thanks ,

    • mathetes's avatar
      mathetes
      Gold Contributor
      Jul 11, 2022

      Since you do have Excel versions of current files (that formed the basis for the images in your first post),would you be so kind as to post the originals (or copies) either on this forum, or on OneDrive or Google Drive. If you use OneDrive or Google, then be sure to post a link to the file.

       

      That way we won't have to go to the trouble of creating them from scratch; it's always easier to work with the requestor's original.

      • Ahmed_Moharam1969's avatar
        Ahmed_Moharam1969
        Copper Contributor
        Jul 12, 2022
        Hi Mathetes ,
        I sent you file attached with message .

        Best Regards
        Ahmed