Make me look like an Excel/VBA Rockstar....

That is only to return focus to the sheet.
Delete that line and the cel.Activate line.

I added this to a module...not sure if I did it right... tools macro , vba module, paste close save.....

However it still appears as the same chart as I scroll through it. Where points appear on the 0 level throughout the scroll.

I really appreciate the insight here fellows... sure would like to buy y'all a beer or two.

Greg, did you right click on the slider and select "assign macro" and then pick the ChartUpdate macro?

ok i did that..... (and deleted the two lines mdmckillop mentioned...(see below) .cool now i have to test it out to ensure that it is working properly.....if it is I have found perhaps the best forum on the net for excel.......

next and hopefully final question for this challenge. Can I duplicate this chart and functions into another, with a different name and then simply paste special the grade input section into the new chart to create a link? Will the Scroll work the same, in both books, where grades for person x will erveal in the second workbook if that name is what appears in the scroll selection? Does that make sense?


Appreciate it.....

Code:

---

Sub ChartUpdate()
    Dim Rng As String, Rw As Long
    Dim cel As Range
    Rw = Range("M1").Value + 2
    'Modify data range
    Rng = "$C$" & Rw & ":$AL$" & Rw
ActiveSheet.ChartObjects("Chart 2").Select
    ActiveChart.SeriesCollection(1).Formula = "=SERIES(,,Sheet1!" & Rng & ",1)"
    'Return activation to sheet
End Sub

---

Quote:

---

Originally Posted by lucas

Greg, did you right click on the slider and select "assign macro" and then pick the ChartUpdate macro?

---

You also need to get rid of the random data by copy/paste special values. Ted's use of it was fine to generate sample data, but it confuses the issue as it changes each time the scrollbar is used.

Try this Greg. I've set the data up as straight values on sheet1, and added the code of Malcolm's

Ted,
I'm getting an error and the file is opening with no data.

Here's my test version

I don't know what I've done to the file...but anyway your version is as good as it gets. Thanks MD

:bow: OK YOU GUYS EXCEL :bow:

I bow in your presence.......

I thought I would never figure this out and in a weekend you all have done so, without fail I will recommend this site for any and all excel challenges. I will go out and buy a VBA book, asap.

THANK YOU SO MUCH.... -- :clap:

Quote:

---

Originally Posted by gregj

I will go out and buy a VBA book, asap.

---

Great news, Then you can help answer questions!

Well I am not so sure about that, but certainly will try where able.

Quote:

---

Originally Posted by mdmackillop

Great news, Then you can help answer questions!

---

I am not going mark this as solved just yet as I might want to figure out the idea of an email alert attached to an instance of a 75 or less for any student whereby if a score of 75 is received in one students "grade - row" it emails me to let me know to move them to the naughty list.....must always whip them... if encouragment is not enough. (J/K) :devil2: If it is a doable thingamabob, then that would be cool to figure out (with expert help) of course.

Best to post that as a new question. You can add a link back to this if necessary.