Hi,

Well i am back again looking for help on my girlfriends thesis.
I have a whole bunch of numbers that need to be graphed.
we have organised our data into aform it is easily graphed, and now we have about 90 graphs to do. (there are alot of numbers)

Is there a way of changing all the references to data for a graph automatically? i tried recording a macro, but the relative cell button did not seem to pick up the right values regardless of weather it was clicked or not, and it put the graph on a new sheet, which was not great.

any help would be great.

thanks
GLenn