i have used reverse data for chart by using

.ReversePlotOrder = True


now my problem is when i try to plot a trendline on the series it creates trendline on normal data & not on reverse data !!!!

so this trend line (21 day moving average line) starts from 21 days before the end of the data to start of the data !!! (without giving any importance to the fact that i have used reverse data)

do i need to reverse trendline as well if yes how?

as my data is reverse (first cell of sheet as last point of chart) i expect my trend line to be like that as well.



can any one help me solve this problem
thanks

regards

vishal