Trend Calculation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I store 3-4 months worth of accuracy values in a table. I would like to be
able to display the information as a rolling average, which I can, but also
show the trend. Any ideas would be appreciatted as at the moment I am stumped.
 
I realize this is a very old post. I am answering in case someone still needs this.

I solved this by inserting a collumn and filling with

IF(this row >xxx and < xxx+yyy , then DATA, else N/a)

xxx and yyy are numbers at the top of the sheet.
I was also able to apply buttons near my chart to change xxx and yyy and see the changes immediatly.

This allowed me to chart this collumn and have the data show up at the correct place on the chart and I could add the trend line to this portion only.
 
Back
Top