Tornado Chart

Hi Fellas, good morning, hope the weekend was good.

Attached is a tornado chart. I would like to insert the Horizontal cat axis lables between
the bars so they appear in the middle of the graph.

Does anybody know how to do this?

Please see attached

Cheers

You need to add a data series to create a gap in the negative section of the scale. This can be used to hold the category names.

You also need to recalculate the values displayed on the left of the chart, which in turn means you need to manual label the value axis with the 0% - 100% labels. This can be done using 2 xy-scatter series. The negative one will require the data labels to be linked to cells in order to display the correct information.

Andy - wow, thanks that looks amazing.

As always, thanks for taking time out of your day to help.

I will go away now to digest your post and try and learn how to do it.