I have to produce individual graphs of pupils performnce figures in 3R's shown against a set target figure. Does anyone know of a way to do this? At present the figures are entered into 3 Excel spreadsheets
Thanks for thought, but need something I'm not sure Excel can do. The target figures will have to be used like a template on each graph and the the variable results added to it. Merging the individual graph into a Word doc!!!!
You can enter the target figures into the spreadsheet and when you create the graph, the format for each line displayed can be altered to suit. So you could set the target plot to a dotted bold red line for extra ugliness.
This thread is now locked and can not be replied to.