#1   Report Post  
Old January 5th 10, 04:00 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 108
Default Trend Line

I have the following header:
Ene-08 Feb-08 Mar-08 Abr-08 May-08 Jun-08 Jul-08 Ago-08

with data.

If I ad a trendline that gives me an equation, lets say: y=-3242x+13

Being x the month, if I want to get data for month Sep-08, what value should
I use for x=9?

Is that applicable for all the months coming, lets say next february 09
would be x=14?

JP

  #2   Report Post  
Old January 5th 10, 04:32 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Trend Line

If your Month values are just text, then yes.
If they are real dates, Sep-08 is 39692, and Feb-09 is 39845, but from the
looks of your data values I would guess that it's more likely to be text.
--
David Biddulph


"juanpablo" wrote in message
...
I have the following header:
Ene-08 Feb-08 Mar-08 Abr-08 May-08 Jun-08 Jul-08 Ago-08

with data.

If I ad a trendline that gives me an equation, lets say: y=-3242x+13

Being x the month, if I want to get data for month Sep-08, what value
should
I use for x=9?

Is that applicable for all the months coming, lets say next february 09
would be x=14?

JP





Reply
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
Trend line for each Joan Excel Worksheet Functions 4 September 27th 09 03:52 AM
How do I set a Trend Line and Remove the Data Line FlexoC Charts and Charting in Excel 2 August 22nd 08 05:15 PM
Trend line AndreasN Charts and Charting in Excel 2 February 12th 05 07:37 PM
trend line does not appear JB Charts and Charting in Excel 1 January 26th 05 08:24 PM
trend line Nee Charts and Charting in Excel 2 January 25th 05 03:11 PM


All times are GMT +1. The time now is 02:01 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017