If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using a chart like a formula...?
Hey,
I want to track the progress of certain "students". 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 "template" (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 |
#2
|
|||
|
|||
Using a chart like a formula...?
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 http://PeltierTech.com/ _______ "DanielWalters6" wrote in message ... Hey, I want to track the progress of certain "students". 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 "template" (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 |
#3
|
|||
|
|||
Using a chart like a formula...?
Thankyou for all your help, I'm going to look into it.
Cheers Dan -- iPod's ROCK! "Jon Peltier" wrote: 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 http://PeltierTech.com/ _______ "DanielWalters6" wrote in message ... Hey, I want to track the progress of certain "students". 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 "template" (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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple filter query of form | truepantera | Using Forms | 6 | August 4th, 2005 08:26 AM |
#N/A Values : Returned by Formulas vs Entered Manually | monir | Charts and Charting | 8 | July 7th, 2005 01:16 AM |
Convert Chart Series Formula to Array Via VBA? | Kevin G | Charts and Charting | 1 | May 5th, 2004 04:52 AM |
Data for Chart with Blank Formula Cells | Frank Kabel | Charts and Charting | 1 | February 16th, 2004 08:42 PM |
Want chart to be blank (gap) where a formula returns blank | Gav !! | Charts and Charting | 4 | January 7th, 2004 02:21 PM |