Year to date Profiled trend line

I need to create a trend line on a bar chart that shows what the figures should be at that point in the year, So i have got the data off how many we should have in a year and in excel i would just di...