ActiveChart.SeriesCollection(1).XValues = "='MySheetName'!R2C2:R12C2" ActiveChart.SeriesCollection(2).XValues = "='MySheetName'!R2C2:R12C2" ActiveChart.SeriesCollection(3).XValues = "='MySheetName'!R2C2:R12C2"but i don't know how to translate the R-C notation. It's obviously referred to Rows and columns but i don't know how to invoke it from VFP.