There are some reference code that I will notify you. I am not providing the entire code, if you are writing just check the references.
Code:
macro= ActiveSheet.Name
ActiveChart.SeriesCollection (1). Name = "= filename.xls! Time" & sheet
This results in something like = filename.xls! table1
But here you need a range, ie something like that:
ActiveChart.SeriesCollection (1) Name = Worksheets (macro) Range ("A1: A10")..
ActiveChart.SeriesCollection (1) Values = Worksheets (macro) Range ("B1: B10")..
Bookmarks