Hb wrote:
trying to set the
labels on the X axis from a column in another Excel sheet
(from the same workbook) programatically from VB.


ActiveChart.SeriesCollection(1).XValues = _
ActiveWorkbook.Sheets("Other").Range("A1:A10")


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup