Question about Dynamic Charts

[Guest]

Using the examples found at
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html#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

 

[Guest]

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

 

[Jon Peltier]

If you read the explanation about the OFFSET function, and if necessary
refer to the help files, you will see that the parameters in OFFSET refer
alternatively to row and column measurements. Swap the arguments within the
function, and you can work with row- or column-based ranges.

- Jon

 

[Jon Peltier]

I didn't mean that to sound snide. Please don't take offense.

- Jon