stacked bar chart with a trend (line)

[1600eads]

Does anyone have a hard answer as to the feasibility of being able to create a stack bar chart with an line graph?

I've read around and cannot seem to find the exact answer.

I tried using the out of box combo chart to create 2 separate bars, along with the line, but the bars cannot be stacked nor do my filters render the visualizations since I'm not using the said dimensions on the combo chart, just in my bars/measures as a set analysis.

Much thanks.

[MatheusC]

@1600eads 
I believe this is because you are using a combo chart, the stacking option comes in the bar chart.

- Matheus

[1600eads]

But then I wouldn't be able to use a line to display a trend (lets say avg)? Which is why I would need a combo chart? I apologize I am not near my computer so I cant test this right away.

[MatheusC]

@Kushal_Chawda  is correct

As well noted. If you have more than one measure in the combined chart you will be able to stack the charts.

What you need to check is that your bar measurements are on the same axis.

So you have a:

Dimension
- 1 measurement – ​​bar: Primary axis
- 1 measurement – ​​bar: Primary axis
- 1 measurement – ​​line: Secondary axis

this should really work


- Matheus