software

Hey,

I want to track the progress of certain quot;studentsquot;. I have their results
from tests that they sit in a register-style worksheet. (Names are in column
A, and scores are under appropriate heading in row 1.)

If I was to create a formula to say add SCORE ONE SCORE TWO SCORE
THREE... I would create a formula that looked like;

=SUM(B2:B26). I would then want that to appear in each row, so I would use
the tiny square in the bottom right hand corner and it would copy down the
formula using dynamic cell references that were corresponding.

All fairly simple stuff.

I would like to make ONE GRAPH. This would simply plot their score against
the name of a test in a line graph. This is simple enough to do for ONE
student, but I can't find a way of using the equivilent to the tiny little
square to make ONE for each student. (The numbers of students can become
quite high.)

I have seen something (I'm pretty sure it was in excel) where as the tutor
moved their cursor over the students name a graph would appear as if it was a
comment. (I hope you know whatI mean by this).

The tutor could move their mouse down the list and each time they stopped
excel would create a graph for them using the particular student's data,
based on a quot;templatequot; (eg. Line graph.)

Does anyone have any idea how this was done.
If you've got any ideas, I would really appreciate some help.

Dan

I could imagine doing this with some kind of VBA procedure, but it would
take a couple hours to make it work. Basically, I'd use the
Worksheet_SelectionChange event to trigger the charting procedure. If the
selected cell was in the appropriate range, I'd use the data from that row
to construct a chart, and I'd position it near the selected cell. When a
different cell is selected I'd kill the one chart and draw another. I guess
it's also possible to reuse one chart, and change the data source when the
selection changed; this can even be done with a defined name (dynamic
range). Or you could predefine all the charts, then have each one become
visible when the appropriate cell was selected.

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

quot;DanielWalters6quot; gt; wrote in message
...
gt; Hey,
gt;
gt; I want to track the progress of certain quot;studentsquot;. I have their results
gt; from tests that they sit in a register-style worksheet. (Names are in
gt; column
gt; A, and scores are under appropriate heading in row 1.)
gt;
gt; If I was to create a formula to say add SCORE ONE SCORE TWO SCORE
gt; THREE... I would create a formula that looked like;
gt;
gt; =SUM(B2:B26). I would then want that to appear in each row, so I would use
gt; the tiny square in the bottom right hand corner and it would copy down the
gt; formula using dynamic cell references that were corresponding.
gt;
gt; All fairly simple stuff.
gt;
gt; I would like to make ONE GRAPH. This would simply plot their score against
gt; the name of a test in a line graph. This is simple enough to do for ONE
gt; student, but I can't find a way of using the equivilent to the tiny little
gt; square to make ONE for each student. (The numbers of students can become
gt; quite high.)
gt;
gt; I have seen something (I'm pretty sure it was in excel) where as the tutor
gt; moved their cursor over the students name a graph would appear as if it
gt; was a
gt; comment. (I hope you know whatI mean by this).
gt;
gt; The tutor could move their mouse down the list and each time they stopped
gt; excel would create a graph for them using the particular student's data,
gt; based on a quot;templatequot; (eg. Line graph.)
gt;
gt; Does anyone have any idea how this was done.
gt; If you've got any ideas, I would really appreciate some help.
gt;
gt; Dan
Thankyou for all your help, I'm going to look into it.

Cheers

Dan
--
iPod's ROCK!quot;Jon Peltierquot; wrote:

gt; I could imagine doing this with some kind of VBA procedure, but it would
gt; take a couple hours to make it work. Basically, I'd use the
gt; Worksheet_SelectionChange event to trigger the charting procedure. If the
gt; selected cell was in the appropriate range, I'd use the data from that row
gt; to construct a chart, and I'd position it near the selected cell. When a
gt; different cell is selected I'd kill the one chart and draw another. I guess
gt; it's also possible to reuse one chart, and change the data source when the
gt; selection changed; this can even be done with a defined name (dynamic
gt; range). Or you could predefine all the charts, then have each one become
gt; visible when the appropriate cell was selected.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;DanielWalters6quot; gt; wrote in message
gt; ...
gt; gt; Hey,
gt; gt;
gt; gt; I want to track the progress of certain quot;studentsquot;. I have their results
gt; gt; from tests that they sit in a register-style worksheet. (Names are in
gt; gt; column
gt; gt; A, and scores are under appropriate heading in row 1.)
gt; gt;
gt; gt; If I was to create a formula to say add SCORE ONE SCORE TWO SCORE
gt; gt; THREE... I would create a formula that looked like;
gt; gt;
gt; gt; =SUM(B2:B26). I would then want that to appear in each row, so I would use
gt; gt; the tiny square in the bottom right hand corner and it would copy down the
gt; gt; formula using dynamic cell references that were corresponding.
gt; gt;
gt; gt; All fairly simple stuff.
gt; gt;
gt; gt; I would like to make ONE GRAPH. This would simply plot their score against
gt; gt; the name of a test in a line graph. This is simple enough to do for ONE
gt; gt; student, but I can't find a way of using the equivilent to the tiny little
gt; gt; square to make ONE for each student. (The numbers of students can become
gt; gt; quite high.)
gt; gt;
gt; gt; I have seen something (I'm pretty sure it was in excel) where as the tutor
gt; gt; moved their cursor over the students name a graph would appear as if it
gt; gt; was a
gt; gt; comment. (I hope you know whatI mean by this).
gt; gt;
gt; gt; The tutor could move their mouse down the list and each time they stopped
gt; gt; excel would create a graph for them using the particular student's data,
gt; gt; based on a quot;templatequot; (eg. Line graph.)
gt; gt;
gt; gt; Does anyone have any idea how this was done.
gt; gt; If you've got any ideas, I would really appreciate some help.
gt; gt;
gt; gt; Dan
gt;
gt;
gt;