I'm trying to build an excel book that records the progress of up to 20 children in a class and displays the results as a graph for each child. Progress is measured with a single score each half term, and compared with a 'norm', in each of three areas: reading, writing and maths.
The data entry table is straightforward. But I can't get the graphs to update dynamically. I want line graphs that change if the data is changed, and that add a segment as each half-term's data is added. Ive created a work book with a page for each child, and four graphs for each child - combined, reading, writing, maths. Each graph contains the individual child's data together with the graph line for the norm.Child Progress Chart (version 3).xlsx
It's got beyond me, and I've spent ages reading online and got muddled up with VBA, Macros, and dynamic tables until my head hurts. So I'm turning to the forum for help.
I am using Excel 2010 for Macintosh, and I attach a copy of the workbook I've created. It's not good, but then if it was, I wouldn't need this forum!
Please could someone help me sort it out.
Bookmarks