Add Trend Line to Excel Chart

Trend lines are the easiest way to find out trend of a data set. Let's take you are selling shoes using amazon.com and ebay.com. This year sales details listed below. You can download data file using this link.

Web Store	January	February	March	April	May	June	July
eBay.com	12	13	20	26	34	32	36
Amazon.com	15	21	24	25	23	18	12

Before adding trend line we need a chart.

Draw a line chart using the above data.

Now we can add trend line for above chart.

write click on any series.

Select 'Add Trend Line' from the pop up menu.

Then new pop up window appear  We can choose behaviors and properties of trend line from this menu.

In this example our chart is amazon.com line is looks like a parabola. So that we can select "Polynomial" as type and set order as two. If you wish to see equation of the trend line tick "Display Equation on Chart".

Now you can close the window to see your trend line.

Add trend lines for both series and see how your selling pattern changing.

We can consider ebay.com line as linear.