Moving Average (Charts)
James, select yr chart and go to Tools/Options/[Chart]. Check the radio
button near "plot empty cells as" for "interpolated" (works for line charts
at least).
GL,
Henk
"Jamesy" wrote:
* Sorry this has been posted in the "General Questions" forum but have placed
it in the incorrect area.
Morning All,
Now I'm not sure if theres a simple answer here but I sure don't know it!!
Heres the layout of my question...
Col A
Jan 1
Jan 2
Jan 3
....
Jan 16
....
Jan 31
Col B
0% (In line with Jan 1)
2% (Jan 2)
4% (Jan 3)
....
27% (Jan 16)
....
45% (Jan 31)
So what I have above is a few % points against a handful of days across a
month. I've plotted these points in a graph and created a "moving average"
line, this works great but I need those % gaps in my actual data.
Is there any way I can get these plots? I can't even display the equation
on the chart.
Your help again is much appreciated.
Thanks,
James.
|