Combined stacked bar and line chart
Does anyone know if it's possible to build a chart that combines stacked bars and lines? Similar to'combined columns an line chart, but with stacked columns instead of just columns.
Any help will be greatly appreciated.
It's definitely possible. One technique I like to use is to add a dual slider, and map that to the range sliders for both charts (then place it on top of the line chart's range slider so the user can't tell I'm using a Dual Slider).
Here's a step-by-step that I just built in Xcelsius.
1. Reproduce the image below:
2. Turn on 'Enable Rance Slider' for both charts and is mapped to G1:G2.
Here it is in action
3. Remove backgrounds and other visual elements from your charts and place them one on top of another, with the dual slider on top of the 2 range sliders.