Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Average (Charts)
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 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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Average (Charts)
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 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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Average (Charts)
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 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. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Average (Charts)
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" wrote in message ... * 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. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving Average (Charts)
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" wrote in message ... * 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Average (Charts) | Excel Discussion (Misc queries) | |||
Moving Average projection? | Excel Worksheet Functions | |||
30 Day Moving Average Ignoring Blank Cells | Excel Worksheet Functions | |||
how do I extract the moving average trendline point data? | Charts and Charting in Excel | |||
Plotting moving average line on a chart | Charts and Charting in Excel |