Line and Stacked Column Chart not working as expected

[SandhyaGiriraj]

Hi Freemanz,

Year-Month	Type	revenue	acc_count
9-2022	A	23890	890
10-2022	A	78900	867
11-2022	A	90078	790
9-2022	B	10256	865
10-2022	B	23567	996
11-2022	B	67890	987
8-2022	C	65789	784
9-2022	C	78906	796
10-2022	C	45890	906

I am trying to create line and stacked column chart using the above table but the chart is not stacking up. But when I used same data for Line and culstered column chart it works fine.

I use Year-Month in Shared axis, and type in column series, revenue in column values and at last I see account in line values.

still I don't see my stacked chart working as expected.

But I want to do line and stacked column chart. Please help 

Thanks

[v-jianboli-msft · Accepted solution]

Hi @SandhyaGiriraj ,

Please try:

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[iroxas24]

why is the line graph not changing when a type is selected?

[iroxas24]

why is the line graph not changing when a type is selected?