Combining a clustered and stacked bar chart

dnicholsby

New Member
Joined
Jan 24, 2017
Messages
26
hi,

I am trying to create a chart that contains both a clustered and a stacked bar chart. The stacked bar chart contains balance sheet data of two segments of a company in 2017. I also have the combined data as at 2018 so I want the 2017 and 2018 data to be a clustered bar chart for comparison. Is this possible? Data is attached


201720172018
GWMGSGCombined
Fixed Assets

<tbody>
</tbody>
96,231,174.00

<tbody>
</tbody>
14,333,422.00

<tbody>
</tbody>
108,925,903.00

<tbody>
</tbody>
Current Assets

<tbody>
</tbody>
60,108,648.00

<tbody>
</tbody>
2,228,483.00

<tbody>
</tbody>
54,586,407.00

<tbody>
</tbody>
Current Liabilities

<tbody>
</tbody>
- 23,950,170.00

<tbody>
</tbody>
- 2,480,282.00

<tbody>
</tbody>
- 28,317,472.00

<tbody>
</tbody>
Non-Current Liabilities

<tbody>
</tbody>
- 10,757,015.00

<tbody>
</tbody>
- 923,776.00

<tbody>
</tbody>
0
Provisions

<tbody>
</tbody>
10,404,175.00

<tbody>
</tbody>
395,343.00

<tbody>
</tbody>
9,163,981.00

<tbody>
</tbody>
Equity

<tbody>
</tbody>
111,228,462.00

<tbody>
</tbody>
25,525,008.00

<tbody>
</tbody>
124,679,507.00

<tbody>
</tbody>

<tbody>
</tbody>

So the GWM and GSG data needs to be combined in a stacked column and you will have 6 different bar charts for each row. I then want to add the 2018 data next to the 2017 data for comparison.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,214,919
Messages
6,122,260
Members
449,075
Latest member
staticfluids

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