Hi,
I badly need help for my report. I'm trying to make a column chart. I have 5 columns A-E, and under each column are several values (500, 450, 440, 320, and so on..)
Volume of Whole Blood unit (126 entries)
Volume of Red Cell only (216 entries)
Volume Loss after component extraction (117 entries)
Volume of Red Cell after Filtration (26 entries)
Volume Loss after Filtration (26 entries)
Is it possible to show the values that fall above, within and below the limits for each variable?
For example, Whole Blood Unit volume limit is 400-500 ml, I would like it to show in single column (or stacked column) the values falling above, within and under.
Is what I'm thinking even possible? I understand conditional formatting can be applied on the table, but I was hoping it can be reflected on the chart as well.
Please help. Thanks in advance.
Bookmarks