graphs

[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

 

[Jon Peltier]

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
_______