Why an I getting error Method 'axes of object' _ chart Failed

I have a chart that ran fine but it was not grabbing enough range off worksheet depending on what data set I used. So I tried to modify the range to include all the rows and If I use my old range for my data series which is

Please Login or Register  to view this content.

The chart comes through fine.

When I use

Please Login or Register  to view this content.

I get error "Method 'axes of object' _ chart Failed"

I am creating a scatter Chart and I am making several ones to run within my macro IS there a template I could use and just modify the ranges to suit each set of data?
Also I notice every data set might have a different range for the Axis and I would like to be able and have the axis get its data from within the data it is pulling with out having to modify by hand.

Here is the total code: I created by recording macro and piecing together.

Please Login or Register  to view this content.

Got it working but it does not seem to capture the range down the entire row.

How could I change it to work.
[code]
ActiveChart.SeriesCollection.NewSeries
ActiveChart.FullSeriesCollection(1).Name = "=BOTTOM!$Y$1"
ActiveChart.FullSeriesCollection(1).XValues = "=BOTTOM!$B$2:$B$4400"
ActiveChart.FullSeriesCollection(1).Values = "=BOTTOM!$Y$2:$Y$4400"
[code]

I need to capture all rows in column b and Y

My data is never constant here is use 4400 rows sometimes it is over 10000.