Thanks!
I was confused by the fact that some call these labels,
some call them values - never thought to look under
XValues!!!
Again, thanks.
-----Original Message-----
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
.