Combine 2 Clustered Column and 1 Secondary Axis Excel

Problem

How to create a combination of 2 Clustered Columns and 1 Axis in excel. it’s not as easy as making a combination of Clustered Columns with Line. If a combination of 2 Clustered Columns occurs, Clustered Column Chart 1 will be blocked by Clustered Column Chart 2 because there is only 1 Axis.

Combine 2 Clustered Column, One Axis, One Secondary Data Excel

Solution

To solve the problem described by dance, it takes 2 Dummy Data with empty values ​​that are placed between 2 Data for 2 Clustered Columns

If the chart has been created with 2 data, namely Data 1 and Data 2, the picture will look like this

If you see in the preview in the picture above, there is a Clustered Column 2 chart blocking Clustered Column 1.

Now you can add 2 Data Series with no value and set the Secondary Axis then the result will be the image below,

For complete steps, you can visit AgungCode.com