Forum Discussion
Line and Stacked Column Chart not working as expected
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
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.
3 Replies
- v-jianboli-msftCommunity Support
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.