Extracting Chart Data and Adjustable Inputs through VBA

Hello all,

I have an interactive moving average chart that needs a few modifications that I cannot seem to accomplish with my lack of VBA. Currently, I have the price and dates for a set of data. I have written a code that automatically plots the moving average of this price data on the chart. It also allows for the moving average to be dynamic (that is, I have constructed it to be adjustable). The problems I am having are as follows:

1) I cannot seem to extract the individual moving average data points from the chart. I have been attempting to work through this, to no avail. I have managed to write a code to extract data from the interactive moving average chart to a worksheet, however, the data that is extracted is for the price, and not for the moving average (even though both price and moving average are plotted on the graph). The only reason I want to extract this data is because I want to calculate the slope of the moving averages and plot these on the chart. If there is a way to create a code that would calculate the slope of each of the moving averages (calculated as current moving average-previous moving average/previous moving average), then I would prefer this to manually calculating it.

2) I have to then, obtain the moving average of the slope (that is, the moving average of the slope of the moving average). Thus, I want to see if there is a way to make an additional input in the Mov_Avg_Chart that allows for an adjustable moving average of the slope. This number will be different than the original moving average period in cell C6. I would like to then have this incorporated in the interactive chart.

I have been reading books and the various websites to no avail...any help would be greatly appreciated.

Maani