Charts - Lining up one data series with another

[whitespace]

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 asa seperate subject altogether.

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

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

 

[shades]

Howdy. Make that a second axis.

 

[whitespace]

Thanks shades but I tried that and still no joy.

Anyone any ideas?

Many thanks for any help.

 

[chergh]

Only way I could get it to work was like this

 

[whitespace]

Hello chergh, thanks a lot for that. To be honest I was hoping to be able to do it by just pulling in the other data series (since we are going to have to generaete a lot of these charts) but this is helpful nonetheless.

Thanks very much for your help