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:
For the overlap I already found a solution: How to Create a Column Chart in Excel with Primary and Secondary Axis Without Bars that Stack over Each Other. 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?