VBA of charting last months dynamically

[tink_]

Hello everyone. I hope there is someone who can help me in the codes of charting the last months dynamically. I want to use the month text box to indicate the last months the user want to plot.For example if you will input 2 in the months text box it will plot the last 2months data. it is like the 12 months rolling data that was posted also here in this forum but you will be using a textbox.

And the other problem is the user only wants to see 2 lines in the chart which is the IN data and OUT data. Please help..Thank you in advance.

Please see attachement and use 51319 as the product code.

tink_

[tink_]

here is the attachement..


tink_