Don,
That did what I wanted.
Played a little with FORECAST, TREND and GROWTH. With no options GROWTH gave the most gain. With option '0' TREND gave the most gain, and GROWTH was off the charts. Will have to watch actual verses 'projected' for a while. Now just have to read up on how to get the 'X' axis to show the Year/Month instead of 1 to N.
Nathan
----- Original Message -----
> From: "Don Wright" <satlug at sbcglobal.net>
> To: "The San Antonio Linux User's Group Mailing List" <satlug at satlug.org>
> Sent: Wednesday, November 9, 2011 10:37:08 PM
> Subject: Re: [SATLUG] Open Office Chart
>> Have you tried setting the predicted data to be a separate range, such
> that one range has values for Jan-2009 to Dec-2011 with empty cells
> for
> the forecast months, and the second range has empty cells for 1/09 to
> 12/11 and values for the forecast months?
>> A quick test showed that empty cells do not get graphed. If you want
> to
> connect the forecast to the actual data, just duplicate the last real
> month data (12/2011) in both the real and forecast series.
>> --
> Price slightly higher west of the Rockies.
> --
> _______________________________________________
> SATLUG mailing list
>SATLUG at satlug.org>http://alamo.satlug.org/mailman/listinfo/satlug to manage/unsubscribe
> Powered by Rackspace (www.rackspace.com)