Trend analysis chart

[Chandrashekar.A]

Hi,

I want to create a trend analysis chart, your help is appreciated. I have attached the spreadsheet also.

Thanks and Regards,
Chandrashekar A

 

[Hui]

Are the gaps in the data relevent or can they be ignored ?

Select A1:M7
Insert
Scatter Chart - Smooth Curves with Markers

 

[Chandrashekar.A]

Are the gaps in the data relevent or can they be ignored ?

Select A1:M7
Insert
Scatter Chart - Smooth Curves with Markers

Those are relevant and please see the attached spreadsheet. But it doesn't look good.

Thank you for your reply.

 

[Hui]

You can also select the chart
Then Select a Series
Right click on the series
Add Trendline
Then select the appropriate parameters

You may wish to read:
http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/
http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/
http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/