I've data ranges (not excel table, just data ranges) mapped from different links having keys on rows and monthly value on columns,
| Column | M1 | M2 | M3 |
|---|---|---|---|
| Key1 | 11 | 21 | 31 |
| Key2 | 12 | 22 | 32 |
| Key3 | 13 | 23 | 33 |
and I'm tryin to create a 100% stacked bar chart showing monthly trend, but whenever I try to crate the graph, it revert to bar chart with no width and overlapping on each other, so i can not understand whats wrong, could any one help
attached Error graph and expected graph (both have equal series overlap (100%) and gap width(70%)
There is an option in excel to use stacked bar graph.
Check here:https://www.educba.com/stacked-bar-chart-in-excel/
I hope you are selecting the entire range.