Hi,
I've been given a tornado chart which works very well, however im struggling to make a small modification to it.
As you can see in the attached file, It starts away from zero if the base number is not zero, I like having the zero line there, but what i'm trying to do is add another line, which goes through the Base value. Ideally I also want to have a data label showing the base value for every midpoint of the tornado (this will be the same number on every row of the chart)
In my attached file I have two tabs, one is the current chart, and the second tab shows the bits i've put in manually that i'm struggling to make it do automatically.
I'm not sure if it's possible to put the second line in? Any thoughts?
Many thanks,
Nick
Bookmarks