excel dynamic charts samples
 

Please send me excel dynamic charts samples. Thanks.

excel dynamic charts samples
 

Hi,

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

Cheers
Andy

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

--

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

excel dynamic charts samples
 

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

Thanks!
Larisa

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

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

--

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

excel dynamic charts samples
 

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

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

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

Thanks!
Larisa

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

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

--

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

excel dynamic charts samples
 

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
_______


"Larisa" wrote in message
...
Can dynamic charts work if the information is going horizontally instead
of
vertically?

Thanks!
Larisa

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

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

--

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