i've got a few dozen sheets full of data that i need to graph.
all sheets are set up/formatted the same, therefore, i will be using the same data range for each chart. (ex.X=$C$6:$C$1000 , Y=$D$6:$D$1000)
the problem i need to overcome:
when i run the macro on sheet 'B' that I recorded on sheet 'A', it still grabs the data from sheet 'A'.
in the example below i recorded the macro on sheet ea13-0243. when i switch to sheet ea13-0244 and run the macro, it uses the data from ea13-0243. What do i need to change in the program to do away with the 'ea13-0243' that will allow the active sheet data be graphed?
Thanks for your help





Sub chart1()
'
' chart1 Macro
' graphs force disp data from MTS
'
' Keyboard Shortcut: Ctrl+Shift+A
'
    ActiveSheet.ChartObjects("Chart 11").Activate
    ActiveSheet.ChartObjects("Chart 11").Activate
    ActiveChart.SeriesCollection(1).Name = "=""Test Data"""
    ActiveChart.SeriesCollection(1).XValues = "='ea13-0243'!$C$6:$C$1000"
    ActiveChart.SeriesCollection(1).Values = "='ea13-0243'!$D$6:$D$1000"
End Sub