Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am trying to create a forecast for some data.
I have dates and quantity. When I plot it the graph is choppy. I can add a trendline. Is there someway for me to add the more important values, min, max a few near the max, then get the values in between which would result in a smooth curve? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Try using a moving average trendline
You cannot arbitrarily add/remove data and expect the trendline to accurately reflect the trend in the original data best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Snarf" wrote in message ... I am trying to create a forecast for some data. I have dates and quantity. When I plot it the graph is choppy. I can add a trendline. Is there someway for me to add the more important values, min, max a few near the max, then get the values in between which would result in a smooth curve? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To have smooth curve using time scale catergory | Charts and Charting in Excel | |||
Does any one have a data set to create an S curve in Excel? | Excel Discussion (Misc queries) | |||
How does Excel smooth chart data when smooth option is selected? | Charts and Charting in Excel | |||
Fill in the blanks to smooth my projection curve | Excel Discussion (Misc queries) | |||
Generate a smooth curve from uneven data points in a "stepped" co. | Excel Worksheet Functions |