I found an example that works: http://www.primeconsultin.com/faqs/faq4650.html

"Adam" wrote:

Using the examples found at
http://www.tushar-mehta.com/excel/ne...tml#BasicRange I was able to create a dynamic chart as shown.

However, does anyone know of any examples where the data is row based (as
opposed to column based?)... I had difficulty figuring how to switch it up.

Thanks,
Adam