Hi all,

I have set of data relative to MIC values of different isolates for a set of antibiotics. Let's say that I have the excel file in attachment where for each strain the MIC values for each antibiotic are reported. Now I want to generate a graph in GraphPad . The graph should report on the X axis the antibioitcs and on the y axis the number of the strain. For each antibiotic, I want three columns, one indicating the number of resistant, one the number of sensitive and the other one the intermediate resistance strains.The number of each of these should be determined according to the breakpoint values. For example for the gentamicin, all the strains with MIC higher than 4 are resistant, = 4 are intermediate and less than 4 sensitive. I have no absolutely idea of how to do this.I am completely new. So could you guide me on how to filter my data and generate this graph?

Thank you very much,

Silvia