I have two data fields I need to combine into one chart. The issue I am having is that I have data for 2019 and thus far 2020. Lets say I need 1 bar for January to be the 2019 total as that is the only information I have, 2020 on the other hand I need to be right next to the 2019 January data, this is where it gets tricky, I have a total for January 2020, but I also have buckets that add up to that total. So lets say January 2020 total was 720 it is separated into 4 categories A, B, C, D. I need to see a bar that is stacked with all 4 of these values showing the total for January 2020 right next to the total for January 2019. Please let me know if you have any ideas. Thank you in advance! Here is my Data:
Months | 2019 | 2020 | A 2020 | B 2020 | C 2020 | D 2020 |
Jan | 700 | 720 | 144 | 180 | 320 | 76 |
Feb | 720 | 710 | 250 | 320 | 100 | 40 |
March | 715 | 730 | 360 | 120 | 100 | 150 |
April | 705 | |||||
May | 810 | |||||
June | 815 | |||||
July | 750 | |||||
August | 775 | |||||
September | 805 | |||||
October | 795 | |||||
November | 750 | |||||
December | 700 | |||||
January | 715 |