B
brian via OfficeKB.com
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
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