It allows for about 20 rows of data above it. What I would like to do is to automatically locate the chart below the last row of data no matter how many rows of data I have so that the chart will never cover any of the data rows. I tried to xldown to the last row and then use RC references from that bottom cell but I have not been sucessful.

The Following User Says Thank You to RetiredGeek For This Useful Post:

RetiredGeek
Thanks for the code. It took me awhile to determine the best way to implement it in my macro. Once done, it works like a charm. The main problem was that I had to abandon using cell references in the addchart stament if favor of using points. Once I did that it all came together.
Thanks Again
Arjay