Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Charting / July 2006

Tip: Looking for answers? Try searching our database.

Changing trend lines with macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brisbane Rob - 20 Jul 2006 20:34 GMT
Hi

Has anyone ever worked out a way of changing trend lines (from sa
linear to moving average) using a macro
Reply to this Message
Tushar Mehta - 20 Jul 2006 23:55 GMT
Turn on the macro recorder (Tools | Macro > Record new macro...), make the
change through the UI, turn off the recorder, and switch to the VBE.  XL
will have generated the necessary code that you can customize/generalize as
required.

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Hi
>
> Has anyone ever worked out a way of changing trend lines (from say
> linear to moving average) using a macro?
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.