I have daily values separated into sheets, one for each year. I am creating a line graph for each year and also adding a moving average with a period of 15 days, however this moving average starts 15 days in as that is when there is can be calculated meaningfully. However, since I have data for previous years, is there a way that I can use this to calculate the moving average without actually plotting this data (as that would mess up the x-axis bounds as I can't set that manually)?

For reference, the official reference does not provide any information on customising Moving Average trendlines.

Please find an image of the current graph below.

enter image description here

| improve this question | | | | |
  • Welcome. Please add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Jan 2 at 19:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.