Basically, I have some data to correspond to X-values and Y-values (only 8 rows of data), and just want to create a chart that does the following:
1) Graphs the moving average trendlines of the data with Period = 2
2) Does so in a way that the trendlines appear in the legend and are color coded (as would automatically occur if I were to just add series).
PLEASE HELP! I'd be so so so so appreciative.
Perhaps I can do something like:
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlLine
but have the "xlLine" somehow display trend lines.
Thanks in advance everyone and thanks for your time reading this.
Bookmarks