Moving Average (Charts)

[Jamesy]

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

 

[HEK]

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]

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
at least).
GL,
Henk

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

 

[Jamesy]

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,

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
at least).
GL,
Henk

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

 

[HEK]

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

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,

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
at least).
GL,
Henk


:

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

 

[Jon Peltier]

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

 

[Jamesy]

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
Options > Axes tab) which plots them on a proportional scale.

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