For this week’s challenge, we are going to modify a previous post for a user request.
If you are not familiar with it, you should check out this post first:
How-to Easily Create a Stacked Clustered Column Chart in Excel
Here is the user request:
1) Given this data set
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | January | February | |||
| 2 | Actuals | Plan | Actuals | Plan | |
| 3 | group A | 250.48 | 300.58 | 187.15 | 155.96 |
| 4 | group B | 306.00 | 367.20 | 382.51 | 318.76 |
| 5 | group C | 315.00 | 378.00 | 425.38 | 354.48 |
| 6 | TOTAL | 871.48 | 1,045.78 | 995.04 | 829.20 |
2) Create a Clustered Stacked Column Chart like this: 
3) Now the challenge and the user request:
How can I close the gaps between the two Clustered Stacked Column Charts WITHOUT spreading the columns outward.
So, the user wants the columns closer like this:
NOT closer like I did in the previous post (i.e. spreading out to fill the space).
Leave me a comment if you have a solution and I will send you an email so that you can send me your file.
Thanks for being a fan and I appreciate all your comments!
Steve=True
