Persistence has paid off and this challenge has been
resolved. My thanks to Tushar Mehta for pointng me in the
right direction

You are welcome. Thanks for letting folks know.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <1a66601c44e65$478294a0$(E-Mail Removed)>,
(E-Mail Removed) says...
> Persistence has paid off and this challenge has been
> resolved. My thanks to Tushar Mehta for pointng me in the
> right direction
>

I had to make two changes:

1) I changed your formula:

PlotData =OFFSET(Sheet1!$B$1,Sheet1!$J$6-1,0,1,COUNTA
(Sheet1!$1:$1)-1)

to:

PlotData =OFFSET(Sheet1!$B$1,Sheet1!$J$6-1,0,1,COUNTA
(Sheet1!$A:$A)-1)

2) Additionally, I was making an error in application of
the formula when I linked the Y values to it; namely, I
had forgotten to start the reference to the formula by
first citing the name of the workbook, e.g. 'My
Workbook.xls'!PlotData.

Again, many thanks for your help

KG
>-----Original Message-----
>You are welcome. Thanks for letting folks know.
>
>--
>Regards,
>
>Tushar Mehta
>www.tushar-mehta.com
>Excel, PowerPoint, and VBA add-ins, tutorials
>Custom MS Office productivity solutions
>
>In article <1a66601c44e65$478294a0$(E-Mail Removed)>,
>(E-Mail Removed) says...
>> Persistence has paid off and this challenge has been
>> resolved. My thanks to Tushar Mehta for pointng me in
the
>> right direction
>>
>.
>