excel dynamic charts samples

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kh - 21 Feb 2006 08:41 GMT

Please send me excel dynamic charts samples. Thanks.

Reply to this Message

Andy Pope - 21 Feb 2006 10:04 GMT

Hi,

http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm

Cheers
Andy

> Please send me excel dynamic charts samples. Thanks.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Larisa - 13 May 2008 16:36 GMT

Can dynamic charts work if the information is going horizontally instead of
vertically?

Thanks!
Larisa

> Hi,
>
[quoted text clipped - 6 lines]
>
> > Please send me excel dynamic charts samples. Thanks.

Reply to this Message

Tushar Mehta (Microsoft MVP Excel 2000-2008) - 13 May 2008 17:28 GMT

Yes. Adjust the OFFSET formula so that you specify 1 row and
COUNTA(...) columns.

>Can dynamic charts work if the information is going horizontally instead of
>vertically?
[quoted text clipped - 12 lines]
>>
>> > Please send me excel dynamic charts samples. Thanks.

Reply to this Message

Jon Peltier - 13 May 2008 19:24 GMT

Sure can. You need to adjust the formulas that define the dynamic range. For
example, adjust the OFFSET formula. The references go like this:

=OFFSET(reference range, rows down from reference range, columns right of
reference range, rows high, columns wide)

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

> Can dynamic charts work if the information is going horizontally instead
> of
[quoted text clipped - 13 lines]
>>
>> > Please send me excel dynamic charts samples. Thanks.

Reply to this Message

Rate this thread: