Dual Axis Graph with Common X Axis

Really struggling with, what I thought was, a relatively simple task displaying two columns (or lines) on the same visual with a common x-axis. As you can see from the screenshot I have a very simple table with 20 rows and 3 columns (ResponseID text, B1 int, and C1 int). I can count the numbers of 1's, 2's, 3's etc. in B1 and display that (see 1st graph) and I can do the same with C1 (see 2nd graph) but what I want to do is overlay the responses of the 2nd graph with the responses of the 1st graph with a common x-axis (whole numbers 1-7). When I try to do this I can't make the x-axis work such that I just get a 1-7 and the two scores. I think what I need to do is create a new table of Score Options (i.e. 1-7) and use that for the x-axis but can't work out how to make it work if that makes sense. Any help provided would be much appreciated.