Overlapping columns with secondary axxis

Question

I am trying to make two columns of value show in a clustered column chart with two columns side-by-side, using a secondary axis for one of the data sets. However, the chart automatically overlaps the two columns. I have seen previous replies that link to a workaround However, if you look at the workaround images carefully you will see that, although the two columns are indeed side by side at the end, they are still both associated with the primary axis.

Here is a clip of the data that is mean to be in the chart - and I have highlighted parameter E as an example.

And below is the solution that the workaround has created - You will see that even though E has data points 24 and 282 - the chart does not show a column of height 24 against the secondary axis as you would have hoped, and the point 24 is still against the primary axis. For clarity I have drawn a blue line where the blue column should have gone to IF it was truly on the secondary axis

So the workaround does still not allow you to have a secondary axis with two columns. Is there a solution to this that works?

Answer 1

Don't put data in the dummy columns. See also: https://answers.microsoft.com/en-us/msoffice/forum/all/is-it-feasible-in-excel-to-create-a-combo-chart/d029b76e-b6b0-4811-b2a0-93534b7bc427

Andreas.