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!
---------------------------------
Moderator's note: Added code tags and corrected typo in thread title
Bookmarks