Hi,

I'm doing a sensitivity analysis for an economic evaluation of anaemia diagnostic methods. I want to create a tornado chart (or two) that look like this one, taken from a Lancet paper:
Lancet tornado chart.png

So there are three groups of ICER (outcome) values:
- 'Low' values
- 'High' values for the same parameters as the Low ones
- Values for changes in model assumptions/subgroups

I can generally do the first two fine, overlapping either side of the vertical axis placed at the base case value, using a Low and High series. However:
(1) If I add a Model series, it just adds them on top of the others. It won't let me have different X axis labels for the different series.
(2) I want to exclude some cells from the selections/diagram, e.g. blank data cells and headings in the list of parameters.
(3) It puts everything in the opposite order from the table. How can I choose the order, e.g. big to small?
(4) I want the data series labels to show percentage change from the base case (given separately in the table), not the ICER values from the Y axis.

File attached.
anaemia model 33.xlsx

Thanks.