Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I plotted months vs numbers in excel and got a trend line with an equation.
When I try to put my xaxis (months) in the trend equation I am getting strange results. -ve results why so? If I replace months with numbers then I get the right answere. Secondly, my graph appears to fit best with the moving average trend but I cann't see the R2 value and the equation for future predictions. What is the easiest way to predict future using trend lines or other features of Excel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
X axis months are truncated?? | Charts and Charting in Excel | |||
How do I eliminate duplicate values on y axis of an Excel chart? | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
interchangine catergory and values axis | Charts and Charting in Excel | |||
catergory on the X axis; values on the Y axis | Charts and Charting in Excel |