excellent, didnt realise you could change chart type for each series. Is there a way of of making the line go across the whole chart though? I'll give a better description of what im trying to do.....
X-axis has company departments on while Y-axis is money(£). I want a line going accross the chart which shows the target £. If i put the value in as a series it only shows up next to the first department. I think that explains it better!