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!

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" <(E-Mail Removed)> wrote in message
news:56160338-5347-443C-9FD7-(E-Mail Removed)...
> 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!

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" <(E-Mail Removed)> wrote in message
> news:56160338-5347-443C-9FD7-(E-Mail Removed)...
> > 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!
>
>
>