Grouping data for graph

20-Jul-17 Elution Pass NA
20-Jul-17 Elution Pass NA
21-Jul-17 Failure Fault  
21-Jul-17 Failure Fault  
21-Jul-17 Elution Pass NA
21-Jul-17 Failure Fault
24-Jul-17 Elution Pass NA
24-Jul-17 Elution Pass NA
24-Jul-17 Elution Pass NA
24-Jul-17 Elution Pass NA
24-Jul-17 Elution Pass NA

 

I have a table full of data like that above. I’m looking to put together a Column Chart of “Mean Time Between Failures”. I want to parse the data so that each column represents total failures in a given week.

 

Any ideas on how to go about this so the chart is automatically updating as I write more rows?

By: Erik

4 thoughts on “Grouping data for graph

  1. ig

    It’s hard to find experienced people for this topic, but you sound like
    you know what you’re talking about! Thanks

  2. Alexandria Martinex

    What¦s Taking place i’m new to this, I stumbled upon this I have found It positively helpful and it has helped me out loads. I hope to contribute & aid different users like its helped me. Great job.

Comments are closed.