VBA coding in Excel

CrazyJoeCrazyJoe Winter Springs, FL Icrontian
edited October 2010 in Science & Tech
I am trying to use MS Excel to create a template that our teachers can use to create a graph to track a students progress in a certain subject against a baseline.

For instance if a kindergarten student is supposed to know 100 words by the end of the year the teacher can test them and put for a certain date they knew x number of words and then display this on a graph.

I have created the data table in excel and it auto formats the chart based on the data with the dates on the x axis and the results of the test on the y axis. I would like it to also be able to set the min/max and scale of the axes based on a value in a certain cell (rather than having the chart automatically decide what it thinks is best or having to manually edit the chart properties.) From what I've read the only way to do this is to write some code. I have found only one site that shows an example of how to do this, but I cannot figure out how to get it to work.

Does anyone here have any idea how to do this and can either send me a template already created or show me to a site that explains how to do this a little clearer than the link that I posted above. It's been way too long since I've written any code and I'm beyond rusty at it.

Thanks in advance!!

Comments

  • kryystkryyst Ontario, Canada
    edited October 2010
    Did you try the autochart add-on that site links to? Won't that do what you need?
  • CrazyJoeCrazyJoe Winter Springs, FL Icrontian
    edited October 2010
    That would work, but the problem would be that every teacher would have to install the addon on their machine. I'd like to just use the code built into Excel because I don't have faith in the ability of the teachers to install it on their own.
  • kryystkryyst Ontario, Canada
    edited October 2010
    Ok fair enough but then your other option is to have it run as a macro, which will cause read flags to pop up every time they open the file and then they'll need to run the macro to get it to update properly.

    While the add-on may be more work upfront could be simpler in the long run. But I don't know how large or spread out your end user pool is so it's hard to say.
  • RichDRichD Essex, UK
    edited October 2010
    depending on the number of max mins you want to be able to set you could use the macro recorder to set the max to value one. then repeat for value two and three and so on. these could then be asigned to a set of buttons on the sheet as some preset options. and no vba coding needed.
Sign In or Register to comment.