I have got 20 sheets in an excel file.Now for the first sheet say "A" i have drawn various charts(20 in no.) in series.
For the remaining 19 sheets i need to draw again 20 charts
for each sheet.The cell nos. for both "x" and "y" axis are the same as for the 20 charts already drawn for sheet "A".
Can you suggest any methos wherein i don't have to select the cells each time corresponding to "x" axis, "y" axis and give a relevant code as the cell nos. for 20 charts in each sheet are the same as for the cell nos. of the 20 charts in sheet "A" which are already drawn.