excel dynamic charts samples

  • Thread starter Thread starter Guest
  • Start date Start date
Can dynamic charts work if the information is going horizontally instead of
vertically?

Thanks!
Larisa
 
Yes. Adjust the OFFSET formula so that you specify 1 row and
COUNTA(...) columns.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calendar Control and Dynamic Chart 1
Dynamic Stock Chart 11
How to create a bubble chart with more than 2 variables 0
dynamic charts - problem with copy 3
Display sample population size in chart i.e. n=X 1
Dynamic and Scrolling charts 2
Dynamic Chart 3
One extra x axis item that wont go away - can anyone help? 3

Back
Top