LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default X-axis months, trend eq doesnot give the right answer, -ve values

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
X axis months are truncated?? Paul28 Charts and Charting in Excel 2 March 27th 05 12:35 AM
How do I eliminate duplicate values on y axis of an Excel chart? Paul Charts and Charting in Excel 1 March 24th 05 04:26 AM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 03:55 AM
interchangine catergory and values axis 100green Charts and Charting in Excel 2 December 16th 04 09:06 PM
catergory on the X axis; values on the Y axis 100green Charts and Charting in Excel 1 December 15th 04 07:06 PM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"