Greetings

I am a new user from South Africa and have been using Excel for many years. However, everytime I think I can call myself an advanced user, I hit a problem that brings me back to earth!

I have a spreadsheet that I use as a template for reasonably repetitive projects. It starts with multiple rows of data. The columns of info of each row remains the same from project to project, but the number of rows varies. I use the data to generate 3 graphs from each row of data. I wish to automate the title of the graph by using a cell from the applicable row. I therefore require relative addressing for the graph title, so that I can easily increase the number of graphs if my number of rows increases.

I can do the absolute addressing, but this requires significant manual editing and I would like to avoid that.

Secondly. The chart title is a concatenation of the variable cell info and a constant text string. I would like the variable info on the first line and the constant string on the second row. Is there a way to automatically do this in the scenario above?

Thanks
Norman