software

Please send me excel dynamic charts samples. Thanks.

Hi,

peltiertech.com/Excel/Charts/Dynamics.html
www.tushar-mehta.com/excel/ne...rts/index.html
www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Cheers
Andy

kh wrote:
gt; Please send me excel dynamic charts samples. Thanks.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

Thanks!
Larisa

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; peltiertech.com/Excel/Charts/Dynamics.html
gt; www.tushar-mehta.com/excel/ne...rts/index.html
gt; www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
gt;
gt; Cheers
gt; Andy
gt;
gt; kh wrote:
gt; gt; Please send me excel dynamic charts samples. Thanks.
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;


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

On Tue, 13 May 2008 08:36:02 -0700, Larisa
gt; wrote:

gt;Can dynamic charts work if the information is going horizontally instead of
gt;vertically?
gt;
gt;Thanks!
gt;Larisa
gt;
gt;quot;Andy Popequot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/Dynamics.html
gt;gt; www.tushar-mehta.com/excel/ne...rts/index.html
gt;gt; www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
gt;gt;
gt;gt; Cheers
gt;gt; Andy
gt;gt;
gt;gt; kh wrote:
gt;gt; gt; Please send me excel dynamic charts samples. Thanks.
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Andy Pope, Microsoft MVP - Excel
gt;gt; www.andypope.info
gt;gt;

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. - PeltierTech.com
_______quot;Larisaquot; gt; wrote in message
...
gt; Can dynamic charts work if the information is going horizontally instead
gt; of
gt; vertically?
gt;
gt; Thanks!
gt; Larisa
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/Dynamics.html
gt;gt; www.tushar-mehta.com/excel/ne...rts/index.html
gt;gt; www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
gt;gt;
gt;gt; Cheers
gt;gt; Andy
gt;gt;
gt;gt; kh wrote:
gt;gt; gt; Please send me excel dynamic charts samples. Thanks.
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Andy Pope, Microsoft MVP - Excel
gt;gt; www.andypope.info
gt;gt;