I'd like to plot a stock chart with open/high/low/close bars ("candlesticks" format) and add a moving average to it. Because of the nature of the data and how I use it, the chart X axis has to be plotted in "reverse order". Once I do that, however, excel calculates the moving average values not starting from the right-most value on the chart, but from the left-most. How would I change this default setting?
Attached is an example of what I'm looking for. I'd like to avoid using 2 charts overlayed on top of one another as my final product is quite large and doing this takes memory and processing speed.
Thank you.
Bookmarks