Add trendline to bar chart

Hello All,

I am having the Bar chart ,And I would like to have the line in the bar chart ,So based it we can show the trend. Below is the result for my data , When I use the trendline from add chart element which is under design tab I am not getting expected result


But I would like to have the below trend line in the above chart

Can any one please help me how can I make it