I recently posted with a question as I needed help showing the next 13 weeks data and the last 13 weeks data. Richy kindly provided me with the attached document, that shows all the data.
I have been trying with limited success on the next part of the puzzle, I need to show the available stock at the time on the chart. This entails:
Starting with today's stock figure, then subtracting the changes made from yesterday, and doing this for 91 todays to provide me with the last 13 weeks stock. This will be showed as weeks as seen on the chart. I don't know if it'll be much different, but this would be done for the next 13 weeks also.
If anyone could advise as to how I should attempt this, it would be appreciated.
