David has attended:
Excel Advanced course
Excel VBA Introduction course
Excel VBA Intermediate course
Excel VBA Advanced course
Stacked Bar Chart and Clustered Bar Chart in One Chart
Hi there,
I am trying to create a chart that has a clustered chart which includes data for a company's balance sheet and next to it a bar chart that compares to the 2017 and 2018 data.
My data is as follows:
2017 Aug-18
GWM GSG Combined
Fixed Assets 96,231,174.00 14,333,422.00 108,925,903.00
Current Assets 60,108,648.00 2,228,483.00 54,586,407.00
Current Liabilities -23,950,170.00 -2,480,282.00 -28,317,472.00
Non-Current Liabilities -10,757,015.00 -923,776.00 -
Provisions 10,404,175.00 395,343.00 9,163,981.00
Equity 111,228,462.00 25,525,008.00 124,679,507.00
The 2017 GWM + GSG data needs to be clustered whereas I only have combined data for August 2018 which needs to be a bar chart next to the 2017 GWM & GSG clustered column so people can compare the two.
Is this possible?
RE: Stacked Bar Chart and Clustered Bar Chart in One Chart
Hi David,
Thank you for the forum question.
Unfortunately it is not possible in a chart to have both stacked and clustered columns, but what about stacked columns and a line chart. This will also do the job to compare the two.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector