View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
hb hb is offline
external usenet poster
 
Posts: 2
Default X axis labels from a Data Source...

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

.