Show horizontal dynamic values in split-axis chart?
I have a client that wants to recreate the below chart. I have already figured out the waterfall bars, but am stumped on how to get the client counts per buckets to be horizontal at the top of the chart as well as dynamic as per the user's selections. I've tried a split axis chart with the bars on the bottom and the count as symbols on the top axis, however these are coming up to scale and my client would like them horizontal like the graph below. Any ideas?
Re: Show horizontal dynamic values in split-axis chart?
Thanks for the quick reply...but unfortunately I can't attach a qvw due to security. But here is a screenshot of what I have right now if that would help. I've hid the top axis, but the symbols are to scale, which I would like to be horizontal. If I make the top axis any smaller, the data labels are cut off. I've thought about trying some set analysis variables here and inputting them into a text object and placing transparently on top of the chart, but that wouldn't make any sense dynamically after selections have been made. I'm open to other ideas as well, I'm not married to the idea of using a split chart, but they do want this view to be dynamic and to be recreated as close as possible to the above chart.