Question about Dynamic Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 25 Oct 2006 14:53 GMT

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

Reply to this Message

Adam - 25 Oct 2006 15:56 GMT

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

> 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.
[quoted text clipped - 4 lines]
> Thanks,
> Adam

Reply to this Message

Jon Peltier - 26 Oct 2006 02:50 GMT

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, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Using the examples found at
> http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html#BasicRange I
[quoted text clipped - 6 lines]
> Thanks,
> Adam

Reply to this Message

Jon Peltier - 26 Oct 2006 03:07 GMT

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> 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
[quoted text clipped - 18 lines]
>> Thanks,
>> Adam

Reply to this Message