I work in a microbiology lab. We test if bugs are Susceptible, Intermediate
or Resistant to a particular antibiotic. In order to make this determination
we look at where a numeric value (we call this an MIC) falls in a set of pre
determined interpretive criteria. I have on a simple chart the number of
samples that obtained a particular MIC, it allows us to see the spread and if
the number heading towards a value that would make them resistant is
emerging. But my question is, can I on the chart show where the column of
samples with a different interpretation to those that have gone before
begins, perhaps a colour change - or a line in the graph area. I know I can
go in and individually change column colours but then can I show on a legend
what each colour means?? Or is there a way to input the interptive criteria??
Hope this makes sense!