hi

Would like pointing in right direction

i have spreadsheet with data as follow

column A (list of name)
column B, C , D etc (labelled 1, 2 3 etc)
data filled in the matrix

I require that the operator can generate the graph easily by name. All the
data is on the same row for each name and all rows are identical range.

Have tried to record macro, however, when amended data range in that macro,
for another name, the title of the graph (name), did not alter

regards

--
bnt

Message posted via http://www.officekb.com