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

Leave a Reply

Your email address will not be published. Required fields are marked *