topic Re: Line and Stacked Column Chart not working as expected in Developer

Line and Stacked Column Chart not working as expected

Anonymous — Tue, 31 Jan 2023 23:16:19 GMT

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

Re: Line and Stacked Column Chart not working as expected

v-jianboli-msft — Wed, 01 Feb 2023 02:16:43 GMT

Hi Anonymous ,

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.

Re: Line and Stacked Column Chart not working as expected

iroxas24 — Tue, 08 Aug 2023 14:44:09 GMT

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

Re: Line and Stacked Column Chart not working as expected

iroxas24 — Tue, 08 Aug 2023 14:44:37 GMT

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