Changing trend lines with macro

B

Brisbane Rob

Hi

Has anyone ever worked out a way of changing trend lines (from sa
linear to moving average) using a macro
 
T

Tushar Mehta

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.

--
Regards,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a linear trend line in Excel 0
Trend lines on data subsets 2
Trend line with negatives Excel 2007 0
linear trend lines do not appear gaps in data 1
Moving average trend line 1
Non Linear Scatter plot, need to find y value 3
changing trend/series data by manipulating chart lines? 1
Changing angle of trend line. 1

Top