G
Guest
Please send me excel dynamic charts samples. Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Larisa
Can dynamic charts work if the information is going horizontally instead of
vertically?
Thanks!
Larisa
vertically?
Thanks!
Larisa
T
Tushar Mehta (Microsoft MVP Excel 2000-2008)
Yes. Adjust the OFFSET formula so that you specify 1 row and
COUNTA(...) columns.
COUNTA(...) columns.
J
Jon Peltier
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
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