Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 4th, 2013, 03:03 PM
Registered User
 
Join Date: Jun 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Change the forward on a trendline using VBA

Hello All,

I hope someone can help.

I have an Excel workbook with a number of line charts, each of which has a trend line. The data for each chart is added to each week up to 18 weeks and the chart changes using named range and offset. The problem is that the trendline for each chart is set at forward to a fixed value, what I would like to do is have the trendline stay at forward to the 18th week regardless of number of data entries that are being plotted eg if I have 14 data entries the forward would be 4, if I had 15 the forward would be 3 etc. Just so I don't have to alter the forward value each week for each chart.

Can this be done? Any help would be appreciated, I am a bit of a novice at VBA.

Many thanks in advance for any help.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Vba to Change Pass Through Query Connection Coby Access VBA 1 April 25th, 2011 09:12 AM
check for change in Excel VBA Poco12 Excel VBA 4 October 26th, 2010 07:37 PM
Change Form Code with VBA emt_101 Access VBA 2 October 17th, 2008 11:45 AM
Change tbl permissions using VBA feets Access VBA 1 October 12th, 2007 01:19 AM
change paper's format with VBA exarkuun Excel VBA 1 December 9th, 2003 11:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.