Moving Average (Charts)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jamesy - 26 Jul 2006 15:01 GMT

* 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 there’s a simple answer here but I sure don't know it!!

Here’s 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.

Reply to this Message

HEK - 26 Jul 2006 22:34 GMT

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

> * Sorry this has been posted in the "General Questions" forum but have placed
> it in the incorrect area.
[quoted text clipped - 34 lines]
> Thanks,
> James.

Reply to this Message

Jamesy - 27 Jul 2006 10:00 GMT

Morning Henk,

Thanks for your response but your below advice does nothing to my line chart?

Any other ideas or am I doing something wrong?

Thanks,
James.

> 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
[quoted text clipped - 40 lines]
> > Thanks,
> > James.

Reply to this Message

Jamesy - 27 Jul 2006 10:37 GMT

Just to clarify what I need from this chart...

I need column B (as shown below) to be fully populated with % figures, so I
can then produce % change across any 2 points in the month.

Thanks,
James.

> Morning Henk,
>
[quoted text clipped - 49 lines]
> > > Thanks,
> > > James.

Reply to this Message

HEK - 27 Jul 2006 22:34 GMT

Sorry, I thought you were getting gaps in the chart, not so much in yr
columns...
If you want to predict "in between values" or even future values you can add
a trendline through yr data points. Excel can be instructed to use a
specific fit, e.g., a polynomial or exponential fit - whatever you anticipate
as being appropriate.
Select yr series, right-click and select Add Trendline.. The parameters
describing the trendline can be calculated with LINEST. Check the helpfile
how to use LINEST.
GL,
Henk

> Just to clarify what I need from this chart...
>
[quoted text clipped - 57 lines]
> > > > Thanks,
> > > > James.

Reply to this Message

Jon Peltier - 28 Jul 2006 03:14 GMT

Do you mean you need wider spaces where there are gaps in the dates? If the
dates are numerical dates, you can use a time scale axis (Chart menu > Chart
Options > Axes tab) which plots them on a proportional scale.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

>* Sorry this has been posted in the "General Questions" forum but have
>placed
[quoted text clipped - 37 lines]
> Thanks,
> James.

Reply to this Message

Jamesy - 31 Jul 2006 09:59 GMT

Thanks for your help guys.

> Do you mean you need wider spaces where there are gaps in the dates? If the
> dates are numerical dates, you can use a time scale axis (Chart menu > Chart
[quoted text clipped - 48 lines]
> > Thanks,
> > James.

Reply to this Message