I am using google sheets to record sales data and have a separate worksheet for each calendar year.

For each calendar year I include a couple of charts which illustrate things like track dollar value of sales per week and I've included a trendline.

Now we've ticked over to a new calendar year, I'd like to include the trendline from last year's dollar value chart into this year's chart, so I can see how the trends compare.

I don't really want to include the week by week data in the chart (it will look messy & I don't need that level of detail) - is there a way I can just include the trend line?

  • Please mark the question as solved so others can benefit as well. Jan 10, 2020 at 17:49
  • @marikamitsos - have done ... I was hoping for some alternative approaches too but none forthcoming!
    – azp74
    Jan 12, 2020 at 4:16

1 Answer 1


I have 'solved' this by pulling in the previous year's data, including the trend line in the series & then setting the colour for the series to none. That way the trendline appears but the individual data points don't.

I suspect this is the right way to do this but I'd be interested to hear of any other approaches.

  • This is great. Still. Could you please also include a sample sheet with dummy data and results (read only or comment only)? It would help others to maybe come up with alternative solutions as your expressed interest. Jan 12, 2020 at 12:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.