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

You have to amend the data ranges for the Y values and for the series name.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"brian via OfficeKB.com" <u15682@uwe wrote in message
news:5d3d3f0f49766@uwe...
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