Thread: [SOLVED] Moving Average (Charts)

* 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.

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 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.

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.

"HEK" wrote:

>
> 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 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.

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.


"Jamesy" wrote:

> 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.
>
> "HEK" wrote:
>
> >
> > 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 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.

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


"Jamesy" wrote:

> 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.
>
>
> "Jamesy" wrote:
>
> > 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.
> >
> > "HEK" wrote:
> >
> > >
> > > 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 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.

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
_______


"Jamesy" <Jamesy@discussions.microsoft.com> wrote in message
news:33F64B91-859E-4D63-9AEF-CC98F6D7584C@microsoft.com...
>* 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.

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
_______


"Jamesy" <Jamesy@discussions.microsoft.com> wrote in message
news:33F64B91-859E-4D63-9AEF-CC98F6D7584C@microsoft.com...
>* 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.

Thanks for your help guys.

"Jon Peltier" wrote:

> 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
> _______
>
>
> "Jamesy" <Jamesy@discussions.microsoft.com> wrote in message
> news:33F64B91-859E-4D63-9AEF-CC98F6D7584C@microsoft.com...
> >* 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.
>
>
>