| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
