Stacked chart combined with regular Bar chart

kac1125

Board Regular
Joined
Jul 31, 2014
Messages
74
Office Version
  1. 365
Platform
  1. Windows
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 2020B 2020C 2020D 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​
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
search for peltier charts, may useful guides there. CHART STUFF in my sig
 
Upvote 0

Forum statistics

Threads
1,214,936
Messages
6,122,340
Members
449,079
Latest member
rocketslinger

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top