Excel graph titles

[SL]

I,m creating a graph and need the a/the title to be created from the tab name or filename. Can this be done? I know this can be done in the header, but it's only visable when printing.

 

[empip]

I am using Excel2000, this is probably not the definitive answer.

Save your spreadsheet. This is important.
Now edit it.

Enter this function in cell A1... (This is one line ) copy / type in exactly as below do not replace "filename" with your own filename
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Pick the bones outa that one then !

This should get you the sheet name in A1.

Within the chart
Create a dummy chart title using normal chart setup process- just use a place holder, for example use the letter a.
Ok the chart.
Click in the title box, edit by deleting the place holder. Shift focus to the formula bar, enter an equals sign, then click in cell A1.
Hit enter.
Chart title should now dynamically reflect the sheet name, looks like :-
=SheetName!$A1$ in the formula bar.

Have a play with that...

 

[SL]

Just what I wanted, fixes to issues I had.

1) graph title.

2) getting filename and / or tab name in a cell.

Many thanks