How to build combo chart with lines for the spend evolution per country and bar behind with the total spend per quarter

[#1]

Hello

I wish I could create a chart in QV like I am use to do in Excel (see in attachment).

I would like to see lines to represent the spend evolution by country

and I want to see bar behind with the total spend per quarter.

I guess I should use "combo chart" but the result is not the one I expect.

could you help me to build this ?

Thanks in advance !

Amélie

[#2]

Hi Amelie,

I think, there is a consistency issue. you try to display in the legend.

-the name of the metric for Grand total

- Values of dimension for the evolution per contry.

I used to do that one time, I overlay 2 graphs, the upper one is transparent. you need to match axes... that's prety long. The result is good but it should'nt be on the best pratices.

But probably someone will have better idea.

Bon courage !!