Forum Discussion
Horizontal Tornado Chart
- 2 years ago
Hi shihanhh
Technically you can achieve it by multiplying values that you want to be under 0 with -1
and hiding "-" of the y-axis with a white shape.
I recorded a short video of creating, you can download it from the link:This is the result:
From the aspect of effective data visualization, these graphs are just unreadable.
Highly recommend reading my blog post about the why and alternatives :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Somthing similar to this.
I have create this by joining two clustered column charts, one inverted.
- Ritaf19832 years agoSuper User
Hi shihanhh
Technically you can achieve it by multiplying values that you want to be under 0 with -1
and hiding "-" of the y-axis with a white shape.
I recorded a short video of creating, you can download it from the link:This is the result:
From the aspect of effective data visualization, these graphs are just unreadable.
Highly recommend reading my blog post about the why and alternatives :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- shihanhh2 years agoFrequent Visitor
I appreciate the work you've put in, but this isn't what I'm looking for. It doesn't display both the positive and negative aspects for each month or QTY as Tornado does. What I'm after is the enrollment and withdrawal data for each QTY or month over the past four years. I managed to achieve this for one year using Tornado, but I also want to present it horizontally. Therefore, I merged the column chart as sent ealier. That does the work but the lines are not alined when I change it to months. (Some lines are thiker that negative lines)