chart source data code
 

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!

chart source data code
 

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


"Knox" wrote in message
...
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!

chart source data code
 

it worked, you are the man!

"Peter T" wrote:

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


"Knox" wrote in message
...
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!