chart source data code

[Guest]

I am trying to select a range for chart data. Can someone enlighten me why
the following line does not work:

ActiveChart.SeriesCollection(1).XValues = _
Sheets("8 count noif ").Range(Cells(5, 11), Cells(12, 11))

Thank you!

 

[Peter T]

Try this -

With Sheets("8 count noif ")
ActiveChart.SeriesCollection(1).XValues = _
..Range(.Cells(5, 11), .Cells(12, 11))
End With

Strange spelling for a sheet name with the trailing space, but it seems to
work OK

Regards,
Peter T

 

[Guest]

it worked, you are the man!

Try this -

With Sheets("8 count noif ")
ActiveChart.SeriesCollection(1).XValues = _
..Range(.Cells(5, 11), .Cells(12, 11))
End With

Strange spelling for a sheet name with the trailing space, but it seems to
work OK

Regards,
Peter T