How to create a bar chart, comparing values with one set on the secondary axis in Excel

The following Table is ready for comparison. When creating a standard bar chart value A and C are not easily comparable. In Excel you cannot display a value within a set on the secondary axis. So I created a column selecting every set individually and set B on a secondary axis the result is this graph.

For the overlap I already found a solution. But the values from Old and New are not next to each other and in the same color.

How can I create a bar chart that let me compare the values Old and New next to each other and also place one set of values on the secondary axis?

Recent Questions...