I have a excell spreadsheet with a micro that worked fine on 2003 and when I upgraded to 2007 it get the error message.
"TheChart.SeriesCollection.Add Source:=Worksheets("Wood & HY Shaft Data").Range(Cells(ActiveCell.Row, "Z"), Cells(ActiveCell.Row, "AG")), SeriesLabels:=True" This is the line Flagged as a problem. Not sure what to change.

Thanks
Don Johnson