I have been struggling to create a graph. I want to show a line for each year showing an average cost. On the x-axis, I want month and then for each month a group of bars showing the volume of records.
I have only managed to do this as two separate graphs, and whenever I combine them, the year and month orders within the shelf do not work properly.
I have created what I am trying to achieve in Excel below. Any help would be greatly appreciated!