You are write, it was a typo. I can not just copy it down, if I do that the column will stay the same, and the row will change.

I need for the referenced column to change and the row to remain the same.

The results should be.
=E8 and the result should be 5
=F8 and the result should be 10 or whatever the next value is.
The values are listed in portrait on the one sheet and the PChart sheet that references it is in landscape. That is where I am haveing the trouble.
Thanks

--
Message posted via http://www.officekb.com