Add trend line to chart.

[svsands26]

I am trying to create two trend lines for sales for 2020 and 2021.

Please see the attached cookie sales sheet.

In 2020 we started sales in mid January so there is no data for the first 3 weeks
In 2021 we started sales January 4th.

Can you assist me in creating a comparison trend line to show how sales for cookies and cakes run for 2020 and 2021?

See attached sample

[Squeaky]

Hi svsands26,
To add a trend line click once on the chart graph to highlight its points, then right click. Find Add Trendline. If you want to compare two trendlines you will have to plot each graph on the chart so there are two sets.