Hi all,

Christ almighty this is driving me insane - it's probably really simple, but I can find no answer to this query anywhere online (at least not for Excel 2013) so I thought I'd post here...

I'm currently trying to create two simple scatter plots plotting data for just four years using the Scatter with Smooth Lines and Markers option. The data, and the charts, are in the spreadsheet below:

Social Mobility in Universities.xlsx

I have managed to create the chart for table 1 just fine by selecting Scatter with Smooth Lines and Markers. The data shows (can't get the data for 2010 off of the Y axis, but oh well that's another problem...) and - crucially - the smooth line is there.

Table 2, however, is another matter: I can get the data to appear just fine, but Excel just plain refuses to add a smooth line. I'm unable to find a way to force Excel to do this. I've even tried simply copying and pasting chart 1, selecting design --> select data and then adding my new data, but to no avail. Once it's added, Excel removes the bloody trend line! I think perhaps the problem may lie in some different quality of the data I'm drawing from in graph 3, which makes Excel think differently.

Apologies if this is an obvious solution, but I've been trying to solve this for the past hour to no avail. Help will be much-appreciated!