automatically creating multiple charts with similar layout and put them in a single sheet

Dear Excel experts,
So far I have found this forum incredibly helpful as I am new to excel/VBA, so I hope you can help me once more!
I have found this very well written macro on http://www.excelforum.com/excel-char...te-graphs.html, and I copied it below.
I have modified one line so to have it running on a selection of data but I am still struggling to do the following:

1/ I want to create a separate sheet where all the graphs are stored rather than having a sheet for each graph
2/ The single charts are time series graphs so they all have the same interval range on the X-axis and one single series of values...how do I instruct excel to understand that?
3/ I want to apply my ad-hoc graphical template to each chart (template already saved and ready)

Can someone tell me how to modify the code below to incorporate 1-3? Thanks soooooo much!

---------------------------------

Please Login or Register  to view this content.

Moderator's note: Added code tags and corrected typo in thread title

I have added code tags for you. Please take the time to review our rules. There aren't many, and they are all important.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here