Charts - Lining up one data series with another

Hello all,

I've got some school data in Excel for 5 subjects and we can create a bar chart of this data no problem. The problem is we need to also display (as a line or points) Lancashire data on top of the bars. I've added another data series but cannot get the points to tie up with the subjects - they all just appear in the middle.

It treats the Lancashire data as a seperate subject altogether.

This is best shown as an example so please see attached file file to demonstrate this in Sheet1.

Have we set the data up incorrectly? Many thanks for any help.

Have a look at Jon's examplanation of how to get the lines in the center of the column rather the cluster.
http://peltiertech.com/Excel/Charts/...olAndLine.html