Hi Guys,
I have to handle a task of report preparation in excel, a part of which enatils me to log the values of vital variables every week and update the graph to show the data for last x weeks. for example, if the range for x axis is c:4 to c:10 the next week will have range from c:5 to c:11.
i have to make similar modifications for around dozen graphs. this task is quite mechanical and i was wondering if a vba scipt could be written to do the same work.
i am new to excel and vba. i have strated reading "Writing Excel Macros with VBA 2nd Edition". But, meanwhile if any of you guys could tell me whether it is possible and if poss. , how it would be a big help.