Tornado Graph with different axis and clustered columns

[Will T]

Hi everyone,

First time poster here. I'm trying to pull together a unicorn I think because I've got a data set per attached. Basically it's to track 4 things:

- No of Approvals
- Value of the approvals
- No of Collections
- Value of the collections

I'm looking at a tornado graph with clustered columns, tracking the no of approvals and collections on side and the dollar value on the other side. Tracking to be on a monthly basis.

Am I trying to do too much?

Much appreciated

[Andy Pope]

It would have helped us to envisage what you describe if you had included a rough sketch, using shapes or hand drawn image, of the desired graphic.

How does the tornado part feature? As what you describe is a column cluster of No. on primary axis and lines for the Values of secondary.
The alignment of line data points would be a problem as the default would be to center between the 2 columns. But with a data rearrange you can get the marker to align with column.
Set the columns to 100% overlap and zero gap.
You will also need to use the select data dialog to choose the join line between empty cells option

THe inner layer of labels is currently just a space but you could use it to identify approval and collection columns