I have data that I'm trying to get into a stacked bar chart, and am having trouble getting it set up right. I have multiple values (A1, A2, B1, B2, C1, C2, etc) across several months. I'd like to stack A1 and A2, B1 and B2, etc, by month. (ex data below)
How do I set up the chart in excel to make it look the way I want??
A1 A2 B1 B2 C1 C2 D1 D2 E1 E2
Feb 25,596 444 18,144 564 17,664 432 16,500 1,020 4,860 180
How do I set up the chart in excel to make it look the way I want??
A1 A2 B1 B2 C1 C2 D1 D2 E1 E2
Feb 25,596 444 18,144 564 17,664 432 16,500 1,020 4,860 180
