Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

stacked bar chart and

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Stacked Bar Chart and Clustered Bar Chart in One Chart

Stacked Bar Chart and Clustered Bar Chart in One Chart

ResolvedVersion 2013

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

Tue 6 Nov 2018: Automatically marked as resolved.

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.